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.

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

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 - 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.

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.

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.

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

When files are not splitable , querying them becomes inefficient.

Answer : B

Explanation

This property controls the logging in Mapreduce tasks

Answer : D

Explanation

All the listed filesystem can be accessed using UDF


hive_questions_answers.htm

Advertisements