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 - Each database created in hive is stored as

A - a directory

B - a file

C - a hdfs block

D - a jar file

Answer : A

Explanation

Each database becomes a directory and each table becomes a file in that directory

Answer : A

Explanation

As the data is stored externally Hive only drops the schema.

Answer : B

Explanation

Partitioning creates subdirectories and only those subdirectories are read to fetch the query result, improving the performance.

Answer : B

Explanation

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

Answer : C

Explanation

CONCAT function accepts any number of arguments

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.

Answer : A

Explanation

Hive is case insensitive

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