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

As indexes are defined on a table, the removal of table partition also removes the respective index.

Answer : A

Explanation

As the data is stored externally Hive only drops the schema.

Q 3 - If the directory for a partition does not exist, and a query is executed for this partition then

A - error is thrown

B - mapreduce job is not triggered

C - Result from a random partition is returned.

D - No result are returned

Answer : D

Explanation

The map reduce job is triggered but no result will be returned.

Q 4 - When the result of the STRING data type is returned by querying array data type using index, the result have

A - no quotes

B - double suotes

C - single quotes

D - No spaces

Answer : A

Explanation

The STRINGS returned form ARRAYS will not contain the quotes.

Answer : C

Explanation

CONCAT function accepts any number of arguments

Q 6 - The Index in Hive can be seen by

A - Describe Index

B - Show Index

C - View Index

D - Find Index

Answer : B

Explanation

Similar to show tables, Indexes can be queried by SHOW Index.

Answer : D

Explanation

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

Q 8 - Hive can automatically decide to run local mode by setting which of the following parameters in hive-site.xml?

A - hive.exec.mode.local.enable

B - hive.exec.mode.cluster.disable

C - hive.exec.mode.local.first

D - hive.exec.mode.local.auto

Answer : D

Explanation

This parameter is used to set local mode.

Q 9 - The command to list the functions currently loaded in a Hive Session is

A - LIST FUNCTIONS

B - SHOW FUNCTIONS

C - DECSRIBE FUNCTIONS

D - FIND FUNCTIONS

Answer : B

Explanation

SHOW FUNCTIONS produces list of all the functions currently available in hive session

Answer : B

Explanation

Macros are created for the purpose of calling other functiuons


hive_questions_answers.htm

Advertisements