Hive Online Quiz


Advertisements


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.

Questions and Answers

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

A - database name

B - database creation time

C - dbproperties

D - directory where the database is stored

Answer : C

Explanation

only dbproperties are changed through this command

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

A - Index

B - Key

C - Value

D - nested Index

Answer : B

Explanation

The MAP data type is a key-value pair and not index based.

Answer : B

Explanation

Hive supports java based regular expression for querying.

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.

Answer : D

Explanation

AN index can be dropped only after dropping the table on which index is created.

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

A - Standard UDF

B - Aggregate UDF

C - Table Generating UDF

D - None

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

A - Hive Pipeline

B - Hive Caching

C - Hive forking

D - Hive Streaming

Answer : D

Explanation

In this type of streaming the code resides in the script being called and Hive is not aware of the code.


hive_questions_answers.htm

Advertisements