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.
Answer : A
Explanation
The schema only refers to the data stored and data is not validated against schema when inserted or loaded.
Q 2 - Using the ALTER DATABASE command in an database you can change the
Answer : C
Explanation
only dbproperties are changed through this command
Q 3 - The partitioning of a table in Hive creates more
A - subdirectories under the database name
Answer : B
Explanation
Partitions of a table creates more subdirectories under it.
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 - The below expression in the where clause
RLIKE '.*(Chicago|Ontario).*';
gives the result which match
A - words containing both Chicago and Ontario
B - words containing either Chicago or Ontario
Answer : B
Explanation
Hive supports java based regular expression for querying.
Q 6 - In case of one large table and 2 small tables, for an optimized query performance
A - The largest one should be cached to memory and small ones should be streamed
B - The small Ones should be cached and large one should be streamed
Answer : B
Explanation
When the small one is cached, each row from the larger table can be efficiently compared with each row of the small table.
Q 7 - If an Index is dropped then
A - The underlying table is also dropped
B - The underlying table is not dropped
Answer : D
Explanation
AN index can be dropped only after dropping the table on which index is created.
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 - The reverse() function reverses a string passed to it in a Hive query. This is an example of
Answer : A
Explanation
reverse(‘abcd’) gives ‘dcba’. So it is a standard UDF.
Q 10 - Calling a unix bash script inside a Hive Query is an example of
Answer : D
Explanation
In this type of streaming the code resides in the script being called and Hive is not aware of the code.
