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

Q 1 - The results of a hive query can be stored as

D - can not be stored

Answer : C

Explanation

Using the command INSERT OVERWRITE DITECTORY ….. data can be exported to both local and hdfs file system.

Q 2 - The 2 default TBLPROPERTIES added by hive when a hive table is created is

A - hive_version and last_modified by

B - last_modified_by and last_modified_time

C - last_modified_time and hive_version

D - last_modified_by and table_location

Answer : B

Explanation

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

Q 3 - In Hive SerDe stands for

A - serialize and Desrialize

B - serializer and Deserializer

C - Serialize and Destruct

D - serve and destruct

Answer : B

Explanation

It is a program to read and write files using Java Input and Output formats.

Q 4 - Partitioned can be prevented from being

A - dropped and queried

B - dropped and renamed

C - Renamed and queried

D - renamed and archived

Answer : A

Explanation

using the ALTER TABLE…….. ENABLE NO_DROP & ENABLE OFFLINE clause.

Q 5 - To select all columns starting with the word 'Sell' form the table GROSS_SELL the query is

A - select '$Sell*' from GROSS_SELL

B - select 'Sell*' from GROSS_SELL

C - select 'sell.*' from GROSS_SELL

D - select 'sell[*]' from GROSS_SELL

Answer : C

Explanation

Hive supports java based regular expression for querying its metadata.

Q 6 - The DISTRIBUTED by clause is used to ensure that

A - similar values go to the same reducer

B - similar values go to same mapper

C - similar values are distributed evenly across all the reducers

D - similar values are distributed evenly across all the mapers

Answer : A

Explanation

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

Q 7 - If an Index is dropped then

A - The underlying table is also dropped

B - The underlying table is not dropped

C - the directory containing the index is deleted

D - Error is thrown by hive

Answer : D

Explanation

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

Q 8 - Which of the following scenarios are not prevented by enabling strict mode in Hive?

A - Scanning all the partitions

B - Generating random sample of data

C - Running a order by clause without a LIMIT clause

D - Cartesian product

Answer : B

Explanation

The other three scenarios create long running job. So STRICT mode is applied to them.

Q 9 - Which of the below is not a type compression option for Sequence file

Answer : C

Explanation

There is no COLUMN compression type for a sequence file

Q 10 - A user creates a UDF which accepts arguments of different data types, each time it is run. It is an example of

A - Aggregate Function

B - Generic Function

C - Standard UDF

D - Super Functions

Answer : B

Explanation

Generic functions are created as java programs and can accept variable data types.

hive_questions_answers.htm

Advertisements