Free Online Hive Mock Test (MCQs)

Free Online Hive Mock Test

After study our Free Apache Hive Quiz Part-I, Part-II, and Part-III you prepared your self for hive interview. This Free Online Hive Mock Test (MCQs), helps you to warm up your apache hive knowledge. This Free Online Hive Mock Test (MCQs), contains some more Trichy & informative questions about Apache Hive.
If you wanna revise Apache Hive before this Free Online Hive Mock Test (MCQs), refer this link Apache Hive Complete guide.

Free Online Hive Mock Test (MCQs)

BEST OF LUCK!!

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

Yes

No

Correct! Wrong!

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

RESET

SET

Correct! Wrong!

Q.3 How to change the column data type in Hive

ALTER and CHANGE

ALTER

CHANGE

Correct! Wrong!

Q.4 Which of the following is the data types in Hive

ARRAY

STRUCT

MAP

All the above

Correct! Wrong!

Q.5 Which of the following is the Key components of Hive Architecture

User Interface

Metastore

Driver

All of the above

Correct! Wrong!

Q.6 Are multiline comments supported in Hive?

Yes

No

Correct! Wrong!

Q.7 Can we run UNIX shell commands from Hive?

Yes

No

Correct! Wrong!

Q.8 Which of the following is the commonly used Hive services

Command Line Interface (cli)

Hive Web Interface (hwi)

HiveServer (hiveserver)

All of the above

Correct! Wrong!

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

True

False

Correct! Wrong!

Q.10 Is it possible to overwrite Hadoop MapReduce configuration in Hive?

Yes

No

Correct! Wrong!

Q.11 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

Correct! Wrong!

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

Mahoot

Hive

Pig

All of the above

Correct! Wrong!

Q.13 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

Correct! Wrong!

Q.14 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

Correct! Wrong!

Q.15 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

Correct! Wrong!

Now you are prepared to face Hive interview. So, let’s some Hive interview questions