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.

Questions and Answers

Answer : B

Explanation

Hive is suited for effectively organizing and querying the store data and not inserting/updating data which is required for OLTP.

Answer : B

Explanation

Hive does not recursively delete the directory. So tables must be dropped first.

Q 3 - Users can pass configuration information to the SerDe using

A - SET SERDEPRPERTIES

B - WITH SERDEPRPERTIES

C - BY SERDEPRPERTIES

D - CONFIG SERDEPRPERTIES

Answer : B

Explanation

This feature of SrrDe is used to customize Hive for a wide range of file formats

Q 4 - Creating  a table an loading it with a select clause in one query applies to

A - only managed tables

B - only external tables

C - Both types of tables

D - Only tables without partitions

Answer : A

Explanation

Only a internal table can be created and loaded with data using one query.

Q 5 - For optimizing join of three tables, the largest sized tables should be placed as

A - the first table in the join clause

B - second table in the join clause

C - third table in the join clause

D - Does not matter

Answer : C

Explanation

Hive reads the tables from left to right. Small tables should be read first and if possible cached into the memory.

Q 7 - When importing data to using SerDe, if a row is found to have more columns than expected then

A - The extra columns are replaced with NULL

B - The row is skipped

C - The import halts with error

D - The Columns are ignored.

Answer : D

Explanation

Hive is schema on Read and It does not throw error for mismatch between schema and actual data.

Answer : C

Explanation

This property controls the compression of the output generated by a query.

Answer : A

Explanation

This property controls the logging in command line Interface.

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