Apache Hive Online Practice Test

Apache Hive Online Practice Test

This Apache Hive Online Practice Test is for freshers and experienced persons in Hive. This Apache Hive Online Practice Test have multiple choice questions (MCQs), which gives you complete knowledge of Big Data. This practice test contains the right answers to each question, refer the link below of each question to explore your knowledge in this field. Apache Hive Online Practice Test contains some tricky Hive interview question, which will help you for prepare Apache Hive interview.
Still, if you are not confident about this Apache Hive Online Practice Test, refer to our article, Apache Hive Comprehensive guide. It will clear your queries.
You May also refer Free Hive Quiz Questions in Part-I and Part-II

Apache Hive Online Practice Test Part-3

ALL THE BEST

Q.1 The tables created in hive are stored as

A file under the database directory

A subdirectory under the database directory

A .java file present in the database directory

A HDFS block containing the database directory

Correct! Wrong!

Q.2 Using the ALTER DATABASE command in an database you can change the

Database name

dbproperties

Database creation time

Directory where the database is stored

Correct! Wrong!

Q.3 In Hive you can copy

The schema without the data

The data without the schema

Both schema and its data

Neither the schema nor its data

Correct! Wrong!

Q.4 The drawback of managed tables in hive is

They are always stored under default directory

They cannot grow bigger than a fixed size of 100GB

They can never be dropped

They cannot be shared with other applications

Correct! Wrong!

Q.5 On dropping a managed table

The schema gets dropped without dropping the data

The data gets dropped without dropping the schema

An error is thrown

Both the schema and the data is dropped

Correct! Wrong!

Q.6 On dropping a external table

The schema gets dropped without dropping the data

The data gets dropped without dropping the schema

An error is thrown

Both the schema and the data is dropped

Correct! Wrong!

Q.7 The 2 default TBLPROPERTIES added by hive when a hive table is created is

hive_version and last_modified by

last_modified_by and last_modified_time

last_modified_time and hive_version

last_modified_by and table_location

Correct! Wrong!

Q.8 The partition of an Indexed table is dropped. then,

Corresponding partition from all indexes are dropped.

No indexes are dropped

Indexes refresh themselves automatically

Error is shown asking to first drop the indexes

Correct! Wrong!

Q.9 What is Hive used as?

Hadoop query engine

MapReduce wrapper

Hadoop SQL interface

All of the above

Correct! Wrong!

Q.10 Which of the following is true for Hive?

Hive is the database of Hadoop

Hive supports schema checking

Hive doesn’t allow row level updates

Hive can replace an OLTP system

Correct! Wrong!

Q.11 Managed tables in Hive:

Can load the data only from HDFS

Can load the data only from local file system

Are useful for enterprise wide data

Are Managed by Hive for their data and metadata

Correct! Wrong!

Q.12 Can the default “Hive Metastore” be used by multiple users (processes) at the same time?

Yes

No

Correct! Wrong!

Q.13 Which of the following query displays the name of the database, the root location on the file system and comments if any.

Describe extended

Show

Describe

Show extended

Correct! Wrong!

Q.14 Which of the following gives the details of the database or schema in a detailed manner.

Describe extended

Show

Describe

Show extended

Correct! Wrong!

Q.15 Which of the following is the join in Hive?

Join

Full outer join

Right outer join

All of the above

Correct! Wrong!

See also – 

Hive Quiz Part 4

Hive Interview Questions