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 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 : B

Explanation

Hive supports java based regular expression for querying.

Answer : A

Explanation

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

Q 7 - Which of the following feature is used to analyze the query execution plan

A - Execute

B - Planner

C - Explain

D - Optimizer

Answer : C

Explanation

EXPLAIN is used to analyze the query execution plan.

Answer : C

Explanation

Streaming a table of small size makes the query faster.

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