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 results of a hive query can be stored as

A - local file

B - hdfs file

C - both

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 - Using the ALTER DATABASE command in an database you can change the

A - database name

B - database creation time

C - dbproperties

D - directory where the database is stored

Answer : C

Explanation

only dbproperties are changed through this command

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

A - DESCRIBE

B - DESCRIBE EXTENDED

C - DESCRIBE FORMATTED

D - DESCRIBE COLUMN

Answer : A

Q 4 - When the result of the STRING data type is returned by querying array data type using index, the result have

A - no quotes

B - double suotes

C - single quotes

D - No spaces

Answer : A

Explanation

The STRINGS returned form ARRAYS will not contain the quotes.

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.

Answer : B

Explanation

When the small one is cached, each row from the larger table can be efficiently compared with each row of the small table.

Answer : A

Explanation

Hive is case insensitive

Answer : B

Explanation

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

Answer : B

Explanation

This property controls the logging in Mapreduce tasks

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