1. What is Apache Hive?
a. A data storage system
b. A relational database
c. A data warehouse infrastructure
d. A NoSQL database
Answer: c. A data warehouse infrastructure
2. Hive uses which language for querying and managing data?
a. SQL
b. Python
c. Java
d. Ruby
Answer: a. SQL
3. What is HiveQL?
a. Hive's query language
b. A Java-based language
c. A scripting language
d. A NoSQL language
Answer: a. Hive's query language
4. Which of the following is true about Hive tables?
a. Hive tables are indexed by default
b. Hive tables are not partitioned
c. Hive tables are schema-on-read
d. Hive tables use a fixed schema
Answer: c. Hive tables are schema-on-read
5. What is the default storage format used by Hive for tables?
a. ORC
b. JSON
c. CSV
d. Avro
Answer: a. ORC
6. Which command is used to create a Hive database?
a. CREATE TABLE
b. CREATE DATABASE
c. CREATE SCHEMA
d. CREATE HIVE
Answer: b. CREATE DATABASE
7. What is Hive's built-in mechanism for indexing data?
a. HBase
b. Solr
c. Elasticsearch
d. Hadoop Distributed Cache
Answer: a. HBase
8. Which Hive component is responsible for metadata storage and retrieval?
a. Hive CLI
b. Hive Metastore
c. Hive Server
d. Hive Compiler
Answer: b. Hive Metastore
9. What is the primary role of a Hive metastore?
a. Storing query results
b. Managing job scheduling
c. Storing metadata about tables and partitions
d. Running SQL queries
Answer: c. Storing metadata about tables and partitions
10. Which command is used to list all databases in Hive?
a. SHOW DATABASES;
b. LIST DATABASES;
c. DESCRIBE DATABASES;
d. SELECT DATABASES;
Answer: a. SHOW DATABASES;
11. Which file format is not suitable for Hive tables?
a. ORC
b. JSON
c. Avro
d. XML
Answer: d. XML
12. How can you add partitions to an existing Hive table?
a. Use the ALTER TABLE command
b. Recreate the table with new partitions
c. Use the HDFS command line
d. Manually edit the table's metadata
Answer: a. Use the ALTER TABLE command
13. Which command is used to run a Hive script?
a. EXECUTE
b. RUN
c. SCRIPT
d. LOAD
Answer: b. RUN
14. What is the purpose of the HiveQL ORDER BY clause?
a. To filter rows in the result set
b. To join tables
c. To sort rows in the result set
d. To create a subquery
Answer: c. To sort rows in the result set
15. In Hive, what does the GROUP BY clause do?
a. Groups rows based on a common column value
b. Filters rows based on a condition
c. Joins tables
d. Selects distinct values from a column
Answer: a. Groups rows based on a common column value
16. What is the role of the Hive SerDe?
a. Query optimization
b. Data serialization and deserialization
c. Data storage
d. Security management
Answer: b. Data serialization and deserialization
17. Which command is used to list all tables in a Hive database?
a. SHOW TABLES;
b. LIST TABLES;
c. DESCRIBE TABLES;
d. SELECT TABLES;
Answer: a. SHOW TABLES;
18. What is the purpose of the Hive JOIN clause?
a. To group rows in a table
b. To filter rows in a table
c. To combine data from two or more tables
d. To sort rows in a table
Answer: c. To combine data from two or more tables
19. Which storage system does Hive use to store its data?
a. HDFS
b. Amazon S3
c. Google Cloud Storage
d. All of the above
Answer: d. All of the above
20. What is the purpose of the Hive EXPLAIN command?
a. To display the result of a query
b. To describe the schema of a table
c. To generate the execution plan of a query
d. To load data into a table
Answer: c. To generate the execution plan of a query
21. Which Hive function is used to aggregate data in a column?
a. GROUP BY
b. AVG
c. SELECT
d. ORDER BY
Answer: b. AVG
22. What is the purpose of Hive's TRANSFORM clause?
a. To change the structure of a table
b. To pivot data
c. To filter rows
d. To run custom scripts on data
Answer: d. To run custom scripts on data
23. Which command is used to load data into a Hive table from an external file?
a. INSERT INTO
b. LOAD DATA INFILE
c. IMPORT DATA
d. ADD DATA
Answer: b. LOAD DATA INFILE
24. What is the default metastore database used by Hive?
a. MySQL
b. HDFS
c. PostgreSQL
d. Derby
Answer: d. Derby
25. Which storage format is best for data compression in Hive?
a. ORC
b. JSON
c. Parquet
d. Avro
Answer: c. Parquet
26. What is the purpose of the Hive UNION clause?
a. To combine the result sets of two or more SELECT statements
b. To join two tables
c. To filter rows in a table
d. To sort rows in a table
Answer: a. To combine the result sets of two or more SELECT statements
27. In Hive, what does the WHERE clause do?
a. Groups rows based on a common column value
b. Filters rows based on a condition
c. Joins tables
d. Sorts rows in the result set
Answer: b. Filters rows based on a condition
28. What is the purpose of the Hive LIMIT clause?
a. To set the number of mappers for a query
b. To limit the number of rows returned in the result set
c. To create a subquery
d. To filter rows based on a condition
Answer: b. To limit the number of rows returned in the result set
29. Which command is used to drop a Hive database?
a. DELETE DATABASE
b. DROP DATABASE
c. REMOVE DATABASE
d. DESTROY DATABASE
Answer: b. DROP DATABASE
30. What is the role of Hive's metastore in query optimization?
a. It optimizes SQL queries
b. It caches query results
c. It stores metadata about tables and partitions for efficient query planning
d. It compiles SQL queries into MapReduce jobs
Answer: c. It stores metadata about tables and partitions for efficient query planning
Top comments (0)