Apache Hive Online Practice Test

All the best for the quiz! - Hive Quiz Part 3

Q.1 The tables created in hive are stored as

A subdirectory under the database directory

A file under the database directory

A HDFS block containing the database directory

A .java file present in the database directory

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

Database name

Database creation time

dbproperties

Directory where the database is stored

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

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

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

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

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

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

Q.9 What is Hive used as?
a. Hadoop query engine
b. MapReduce wrapper
c. Hadoop SQL interface

a

b

c

All of the above

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

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

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

YES

NO

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

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

Describe extended

Show

Describe

Show extended

Q.15 Which of the following is the join in Hive?
a. Join
b. Full Outer Join
c. Right Outer Join

a

b

c

All of the above

Your email

Apache Hive Online Practice Test

Apache Hive Online Practice Test

Leave a Reply Cancel reply