Hive Quiz 2 | Englishfreetest.com

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

Here's the exercise 'Hive Quiz 2 | 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: HiveServer2 introduced in Hive 0.11 has a new CLI called __________
    A. BeeLine
    B. SqlLine
    C. HiveLine
    D. CLilLine
    Question 2: Each database created in hive is stored as
    A. a directory
    B. a file
    C. a HDFS book
    D. a jar file
    Question 3: A user creates a UDF which accepts arguments of different data types, each time it is run. It is an example of
    A. Aggregate Function
    B. Generic Function
    C. Standard UDF
    D. Super Functions
    Question 4: On dropping a managed table
    A. The schema gets dropped without dropping the data
    B. The data gets dropped without dropping the schema
    C. An error is thrown
    D. Both the schema and the data is dropped
    Question 5: Which of the below is not a type compression option for Sequence file
    A. Record
    B. Block
    C. Column
    D. None
    Question 6: What Hive can not offer?
    A. Storing data in tables and columns
    B. Online transaction processing
    C. Handling date time data
    D. Partitioning stored data
    Question 7: 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 8: By default when a database is dropped in Hive
    A. The tables are also deleted
    B. The directory is deleted if there are no tables
    C. The hdfs blocks are formatted
    D. none
    Question 9: The drawback of managed tables in hive is
    A. They are always stored under default directory
    B. They cannot grow bigger than a fixed size of 100GB
    C. They can never be dropped
    D. They cannot be shared with other applications
    Question 10: What can be altered about a view
    A. its name
    B. its location
    C. its TBLPROPERTIES
    D. The query it is based on