Hive Quiz 5 | Englishfreetest.com

  • Do test 20 minutes
  • Number Questions: 10 questions
  • By: englishfreetest.com
Do test

Here's the exercise 'Hive Quiz 5 | Englishfreetest.com' about Technical Quiz - Technical Tests.


Put your knowledge about all things technology to the test Because everything tech, from computers and the internet to software and big data, changes rapidly on a day-to-day basis, it’s now a must to stay up to date with the technology that dominates our modern day lives. Are you up to speed on what’s going on in the tech industry today? Take our quiz to find out. Test how much you know about technology

You can find more to the lesson and more exercises. Technical Quiz - Technical Tests in here.

Finally, click here to "Test" for start practice exercise .

  • Test content
    Question 1: While querying a hive table for a Array type column, if the array index is nonexistent then
    A. NULL is returned
    B. Error is reported
    C. Partial results are returned
    D. NA is returned
    Question 2: The default limit to the number of rows returned by a query can be done using which of the following parameter?
    A. hive.limit.optimize.enable
    B. hive.limit.enable.optimize
    C. hive.optimize.enable.limit
    D. hive.enable.limit.optimize
    Question 3: The name of a view in Hive
    A. can be same as the name of another table in the same database
    B. cannot be same as the name of another table in the same database
    C. cannot contain a number
    D. cannot be more than 10 character long
    Question 4: To add a new user defined Function permanently to Hive, we need to
    A. Create a new version of Hive
    B. Add the .class Java code to FunctionRegistry
    C. Add the .jar Java code to FunctionRegistry
    D. Add the .jar java code to $HOME/.hiverc
    Question 5: If the schema of the table does not match with the data types present in the file containing the table then HIve
    A. Automatically drops the file
    B. Automatically corrects the data
    C. Reports Null values for mismatched data
    D. Does not allow any query to run on the table
    Question 6: Aggregate functions in Hive are the function which
    A. Takes one or more columns form a row and returns a single value
    B. Takes one or more columns form many rows and returns a single value
    C. Take zero or more inputs and produce multiple columns or rows of output
    D. Detects the type of input programmatically and provides appropriate response
    Question 7: When one of the join tables is small enough to fit into memory, The type of join used by Hive is
    A. Inner Join
    B. Map join
    C. Reduce Join
    D. Sort Join
    Question 8: in hive when the schema does not match the file content
    A. It cannot read the file
    B. It reads only the string data type
    C. it throws an error and stops reading the file
    D. It returns null values for mismatched fields
    Question 9: The DISTRIBUTED BY clause in hive
    A. comes Before the sort by clause
    B. comes after the sort by clause
    C. does not depend on position of sort by clause
    D. cannot be present along with the sort by clause
    Question 10: In Hive SerDe stands for
    A. serialize and Desrialize
    B. serializer and Deserializer
    C. Serialize and Destruct
    D. serve and destruct