Apache Hive Online Practice Test

1. Question

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

2. Question

Using the ALTER DATABASE command in an database you can change the

Database name
dbproperties
Database creation time
Directory where the database is stored

3. Question

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

4. Question

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

5. Question

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

6. Question

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

7. Question

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

8. Question

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

9. Question

What is Hive used as?

Hadoop query engine
MapReduce wrapper
Hadoop SQL interface
All of the above

10. Question

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

11. Question

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

12. Question

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

Yes
No

13. Question

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

14. Question

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

Describe extended
Show
Describe
Show extended

15. Question

Which of the following is the join in Hive?

Join
Full outer join
Right outer join
All of the above