Free Online Hive Mock Test (MCQs)

1. Question

Is it possible to change the default location of Managed Tables in Hive

Yes
No

2. Question

Which among the following command is used to change the settings within Hive session

RESET
SET

3. Question

How to change the column data type in Hive

ALTER and CHANGE
ALTER
CHANGE

4. Question

Which of the following is the data types in Hive

ARRAY
STRUCT
MAP
All of the above

5. Question

Which of the following is the Key components of Hive Architecture

User Interface
Metastore
Driver
All of the above

6. Question

Are multiline comments supported in Hive?

Yes
No

7. Question

Can we run UNIX shell commands from Hive?

Yes
No

8. Question

Which of the following is the commonly used Hive services

Command Line Interface (cli)
Hive Web Interface (hwi)
HiveServer (hiveserver)
All of the above

9. Question

Explode in Hive is used to convert complex data types into desired table formats.

True
False

10. Question

Is it possible to overwrite Hadoop MapReduce configuration in Hive?

Yes
No

11. Question

Point out the correct statement

Hive is not a relational database, but a query engine that supports the parts of SQL
Hive is a relational database with SQL support
Pig is a relational database with SQL support
None of the above

12. Question

Which of the following is used to analyse data stored in Hadoop cluster using SQL like query

Mahoot
Hive
Pig
All of the above

13. Question

If an Index is dropped then

The directory containing the index is deleted
The underlying table is not dropped
The underlying table is also dropped
Error is thrown by hive

14. Question

If the schema of the table does not match with the data types present in the file containing the table then Hive

Automatically drops the file
Automatically corrects the data
Reports Null values for mismatched data
Does not allow any query to run on the table

15. Question

By default when a database is dropped in Hive

The tables are also deleted
The directory is deleted if there are no tables
The HDFS blocks are formatted
None of the above