Question 1

In Apache Hive, what does the command DESCRIBE table_name do?

Accepted Answer

It provides details about the structure of a specified table

Answer

It removes the table from the database

Answer

It updates records in the table

Answer

It retrieves all data from the table

Question 2

Which DML command in Apache Hive is used to retrieve data from a table?

Accepted Answer

SELECT

Answer

DELETE

Answer

INSERT

Answer

UPDATE

Question 3

Which command in Apache Hive is used to create a new table?

Accepted Answer

CREATE TABLE

Answer

SELECT

Answer

INSERT INTO

Answer

DROP TABLE

Question 4

What does the INSERT INTO command do in Apache Hive?

Accepted Answer

It adds data to an existing table

Answer

It deletes a table

Answer

It retrieves data from a table

Answer

It modifies the structure of a table

Question 5

Which of the following DDL commands is used to remove a table from a Hive database?

Accepted Answer

DROP TABLE

Answer

CREATE TABLE

Answer

DESCRIBE TABLE

Answer

ALTER TABLE

Question 6

What is the purpose of the ALTER TABLE command in Apache Hive?

Accepted Answer

To modify an existing table's structure

Answer

To load data into a table

Answer

To create a new database

Answer

To query data from a table

Question 7

Which command would you use to change the name of an existing table in Apache Hive?

Accepted Answer

ALTER TABLE ... RENAME TO

Answer

DROP TABLE

Answer

CREATE TABLE

Answer

INSERT INTO

Question 8

In Apache Hive, which command is used to delete specific rows from a table?

Accepted Answer

DELETE

Answer

DROP

Answer

TRUNCATE

Answer

INSERT

Question 9

Which of the following actions does the SHOW TABLES command perform in Apache Hive?

Accepted Answer

It lists all tables in the current database

Answer

It creates a new table

Answer

It drops a table from the database

Answer

It describes the structure of a specific table

Question 10

Which SQL clause is used to filter records in Apache Hive?

Accepted Answer

WHERE

Answer

GROUP BY

Answer

ORDER BY

Answer

SELECT

Question 11

Which clause in an SQL query is used to filter records that meet a specific condition in Apache Hive?

Accepted Answer

WHERE

Answer

HAVING

Answer

ORDER BY

Answer

SELECT

Question 12

Which clause in an Apache Hive query is used to sort the result set?

Accepted Answer

ORDER BY

Answer

HAVING

Answer

WHERE

Answer

GROUP BY

Related quizzes

Related quizzes