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.

Answer : D

Explanation

As they are managed by Hive metadata, other applications cannot access it.

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.

Answer : B

Explanation

It is up to the user to ensure the synchronization between schema and data

Q 5 - An element in a STRUCT column in hive is referred by

A - index

B - key

C - colon

D - dot

Answer : D

Explanation

STRUCT elements are key-value pairs and the elements are accessed by dot notation.

Answer : A

Explanation

The DISTRIBUTED BY clause send a range of values to the same reducer.

Answer : D

Explanation

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

Answer : B

Explanation

Local mode avoid creating mapreduce job while running the job in a single machine.

Answer : B

Explanation

This property controls the logging in Mapreduce tasks

Q 10 - Which of the following File Formats are supported by Hive?

A - Text Files

B - Sequnce FIles

C - RC Files

D - All of the above

Answer : D

Explanation

Hive supports all these three file formats as they are also supported by Hadoop in general

hive_questions_answers.htm
Advertisements