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.

Answer : B

Explanation

These are the 2 properties which are by default added by Hive

Answer : B

Explanation

Partitions of a table creates more subdirectories under it.

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 - The property set to run hive in local mode as true so that it runs without creating a mapreduce job is

A - hive.exec.mode.local.auto

B - hive.exec.mode.local.override

C - hive.exec.mode.local.settings

D - hive.exec.mode.local.config

Answer : A

Explanation

In local mode hive will not trigger a mapreduce job.

Q 6 - A view in Hive can be seen by using

A - SHOW TABLES

B - SHOW VIEWS

C - DESCRIBE VIEWS

D - VIEW VIEWS

Answer : A

Explanation

There is no separate clause for viewing views. It is shown using show tables.

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.

Q 8 - The default limit to the number of rows returned by a query can be done using which of the following parameter?

A - hive.limit.optimize.enable

B - hive.limit.enable.optimize

C - hive.optimize.enable.limit

D - hive.enable.limit.optimize

Answer : A

Explanation

This parameter is configured to change the default value of the number of rows returned

Answer : B

Explanation

This property controls the logging in Mapreduce tasks

Q 10 - Hive supports row-level Inser/update and Delete using the ACID features only on which file format?

A - SequenceFile

B - Text File

C - ORC file

D - RC file

Answer : C

Explanation

Except the ORC file all other files types do not support insert or update.


hive_questions_answers.htm

Advertisements