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 tables created in hive are stored as

A - a subdirectory under the database directory

B - a file under the database directory

C - a hdfs block containing the database directory

D - a .java file present in the database directory

Answer : A

Explanation

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

Q 3 - Users can pass configuration information to the SerDe using

A - SET SERDEPRPERTIES

B - WITH SERDEPRPERTIES

C - BY SERDEPRPERTIES

D - CONFIG SERDEPRPERTIES

Answer : B

Explanation

This feature of SrrDe is used to customize Hive for a wide range of file formats

Q 4 - The position of a specific column in a Hive table

A - can be anywhere in the table creation clause

B - must match the position of the corresponding data in the data file

C - Must match the position only for date time data type in the data file

D - Must be arranged alphabetically

Answer : B

Explanation

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

Q 5 - The below expression in the where clause

RLIKE '.*(Chicago|Ontario).*';

gives the result which match

A - words containing both Chicago and Ontario

B - words containing either Chicago or Ontario

C - words Ending with Chicago or Ontario

D - words starting with Chicago or Ontario

Answer : B

Explanation

Hive supports java based regular expression for querying.

Q 6 - The name of a view in Hive

A - can be same as the name of another table in the same database

B - cannot be same as the name of another table in the same database

C - cannot contain a number

D - cannot be more than 10 character long

Answer : B

Explanation

Views and tables are treated similarly in the hive metadata

Q 7 - If the data on the table on which an index is defined changes then,

A - The Index becomes invalid

B - The index rebuilds automatically

C - The Index has to be rebuilt manually

D - The index must be dropped

Answer : C

Explanation

Hive does not manage the Index like RDBMS. SO it has to be built manually.

Q 8 - Hive.exec.compress.output controls

A - The output compression of map tasks

B - The output compression of reduce tasks

C - The output compression of query result

D - All of the above

Answer : C

Explanation

This property controls the compression of the output generated by a query.

Q 9 - Which file controls the logging of commands put in CLI?

A - hive-log4j.properties

B - hive-exec-log4j.properties

C - hive-cli-log4j.properties

D - hive-create-log4j.properties

Answer : A

Explanation

This property controls the logging in command line Interface.

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