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

Q 1 - The default delimiter in hive to separate the element in STRUCT is

A - '\001'

B - '\oo2'

C - '\oo3'

D - '\oo4'

Answer : B

Explanation

The four default delimiters are − \n for record separator,

001\ for field separator

002\ for element separator in ARRAY or STRUCT

003\ for element separator in MAP

Answer : B

Explanation

Hive does not recursively delete the directory. So tables must be dropped first.

Answer : B

Explanation

It is up to the user to ensure the synchronization between schema and data

Q 5 - The performance of an aggregate query is improved by setting which of the following property as true?

A - hive.map.group

B - hive.map.aggr

C - hive.map.sort

D - hive.map.sum

Answer : B

Explanation

SET hive.map.aggr = true;

Q 6 - Which kind of keys(CONSTRAINTS)  Hive can have?

A - Primary Keys

B - Foreign Keys

C - Unique Keys

D - None

Answer : D

Explanation

Hive is schema on read and unlike RDBMS it does not have a way to enforce the existence of keys.

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

Explanation

Local mode avoid creating mapreduce job while running the job in a single machine.

Q 9 - The command to list the functions currently loaded in a Hive Session is

A - LIST FUNCTIONS

B - SHOW FUNCTIONS

C - DECSRIBE FUNCTIONS

D - FIND FUNCTIONS

Answer : B

Explanation

SHOW FUNCTIONS produces list of all the functions currently available in hive session

Q 10 - The Hive metadata can be easily created and edited using

A - HCatalog

B - HMetamanager

C - Hweblog

D - Hue

Answer : A

Explanation

Hcatalog stores metadata information for many Hadoop tools like Hive and Mapreduce. It can be accessed through a web interface.


hive_questions_answers.htm


Advertisements
E-Books Store