Quiz on Introduction to Hive

What is Hive primarily used for?

• Data Visualization

• Data Warehousing

• Data Mining

• Data Backup

Which component does Hive use for storage?

• Cassandra

• HBase

• MySQL

• HDFS

What is the default file format in Hive?

• RCFile

• Text File

• Sequence File

• Parquet

Which of the following is a type of Hive table?

• Temporary Table

• Managed Table

• Dynamic Table

• Static Table

What does DDL stand for in Hive?

• Data Definition Language

• Data Distribution Language

• Data Description Language

• Data Deployment Language

Which of the following is NOT a Hive data type?

• CHARACTER

• STRING

• BOOLEAN

• FLOAT

What is the purpose of the Metastore in Hive?

• To execute queries

• To visualize data

• To manage metadata

• To store data

Which command is used to create a database in Hive?

• CREATE DATABASE

• NEW DATABASE

• MAKE DATABASE

• ADD DATABASE

What is the main difference between static and dynamic partitions?

• Both are the same

• Dynamic requires user input, static does not

• Static is faster than dynamic

• Static requires user input, dynamic does not

Which of the following is a collection data type in Hive?

• ARRAY

• STRING

• FLOAT

• BOOLEAN