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

Q 1 - Each database created in hive is stored as

A - a directory

B - a file

C - a hdfs block

D - a jar file

Answer : A

Explanation

Each database becomes a directory and each table becomes a file in that directory

Answer : B

Explanation

Partitions of a table creates more subdirectories under it.

Answer : A

Explanation

using the ALTER TABLE…….. ENABLE NO_DROP & ENABLE OFFLINE clause.

Q 5 - The clause used to limit the number of rows returned by a query is

A - LIMIT

B - ROWNUM

C - RESTRICT

D - MAXROW

Answer : A

Explanation

LIMIT restricts the number of rows returned by a query.

Answer : A

Explanation

Sorting as the last clause will be efficient as that is also the last step in the reduce job producing the output.

Answer : A

Explanation

The query is run on complete data set and then the results are restricted using LIMIT clause.

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 10 - When one of the join tables is small enough to fit into memory, The type of join used by Hive is

A - Inner Join

B - Map join

C - Reduce Join

D - Sort Join

Answer : B

Explanation

As one of the tables already fits into the memory each row of the big table is quickly compared with each row of small table using Map Join.


hive_questions_answers.htm

Advertisements