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 - Which of the following is not a complex data type in Hive?

Answer : A

Explanation

There is no Matrix data type in Hive.

Q 2 - The difference between the MAP and STRUCT data type in Hive is

A - MAP is Key-value pair but STRUCT is series of values

B - There can not be more than one MAP dat type column in a table but more than one STRUCT data type in a table is allowed.

C - The Keys in MAP can not be integers but in STRUCT they can be.

D - Only one pair of data types is allowed in the key-value pair of MAP while mixed types are allowed in STRUCT.

Answer : D

Explanation

Each element in MAP type should be of same data type but in STRUCT it need not be so.

Q 3 - To see the data types details of only a column (not the table) we should use the command

B - DESCRIBE EXTENDED

C - DESCRIBE FORMATTED

D - DESCRIBE COLUMN

Answer : A

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 - An element in a STRUCT column in hive is referred by

Answer : D

Explanation

STRUCT elements are key-value pairs and the elements are accessed by dot notation.

Q 6 - The Index in Hive can be seen by

A - Describe Index

Answer : B

Explanation

Similar to show tables, Indexes can be queried by SHOW Index.

Q 7 - The clause " WITH DEFERRED REBUILD" while creating an index

A - creates index on a table which is yet to be created

B - creates index on a table which has no data

C - creates index only on a table which has data

D - creates an index which is empty

Answer : D

Explanation

It is about creating index on an empty table.

Q 8 - The Property that decides what is the maximum number of files that can be sampled during the use of the LIMIT clause is

A - hive.limit.optimize.file.max

B - hive.limit.optimize.limit.file

C - hive.limit.optimize.file.restrict

D - hive.limit.optimize.limit.most

Answer : B

Explanation

This property decides the number files to be looked into for the sample result.

Q 9 - A Table Generating Function is a Function that

A - Takes one or more columns form a row and returns a single value

B - Takes one or more columns form many rows and returns a single value

C - Take zero or more inputs and produce multiple columns or rows of output

D - Detects the type of input programmatically and provides appropriate response

Answer : C

Explanation

Examples functions is Explode()

Q 10 - When one of the join tables is small enough to fit into memory, The type of join used by Hive is

C - Reduce Join

Answer : B

Explanation

As one of the tables already fits into the memory each row of the big table is quickly compared with each row of small table using Map Join.

hive_questions_answers.htm

Advertisements