Hive Online Quiz
Following quiz provides Multiple Choice Questions (MCQs) related to Hive. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.
Q 1 - What Hive can not offer
A - storing data in tables and columns
Answer : B
Explanation
Hive is suited for effectively organizing and querying the store data and not inserting/updating data which is required for OLTP.
Q 2 - The drawback of managed tables in hive is
A - they are always stored under default directory
Answer : D
Explanation
As they are managed by Hive metadata, other applications cannot access it.
Q 3 - In Hive SerDe stands for
Answer : B
Explanation
It is a program to read and write files using Java Input and Output formats.
Q 4 - While querying a hive table for a column with MAP data type, the elements in the column are referenced by
Answer : B
Explanation
The MAP data type is a key-value pair and not index based.
Q 5 - To select all columns starting with the word 'Sell' form the table GROSS_SELL the query is
A - select '$Sell*' from GROSS_SELL
B - select 'Sell*' from GROSS_SELL
Answer : C
Explanation
Hive supports java based regular expression for querying its metadata.
Q 6 - A view in Hive can be seen by using
Answer : A
Explanation
There is no separate clause for viewing views. It is shown using show tables.
Q 7 - The clause " WITH DEFERRED REBUILD" while creating an index
A - creates index on a table which is yet to be created
B - creates index on a table which has no data
Answer : D
Explanation
It is about creating index on an empty table.
Q 8 - Which of the following hint is used to optimize the join queries
A - /* joinlast(table_name) */
B - /* joinfirst(table_name) */
Answer : C
Explanation
Streaming a table of small size makes the query faster.
Q 9 - Which file controls the logging of commands put in CLI?
Answer : A
Explanation
This property controls the logging in command line Interface.
Q 10 - The UDF can access files inside
Answer : D
Explanation
All the listed filesystem can be accessed using UDF