Which SQL keyword is used to remove a table from the database? MCQ with Answer and Explanation

Question

Share Report Error

Which SQL keyword is used to remove a table from the database?

A. REMOVE

B. TRUNCATE

C. DROP

D. DELETE

Answer: Option C

Solution (By JKSSB Mock Tests)

DROP TABLE is a DDL command that deletes the table and its structure from the database.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

Which normal form requires that every determinant is a candidate key?

A. 3NF

B. 1NF

C. BCNF

D. 2NF

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Boyce-Codd Normal Form (BCNF) is a stricter version of 3NF where every determinant must be a candidate key.

This question belongs to: Computer Database Management System (DBMS)

Question #2

Which of the following is a valid SQL data type for storing decimal numbers with exact precision?

A. DOUBLE

B. FLOAT

C. DECIMAL

D. REAL

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
DECIMAL (or NUMERIC) is used for exact numeric values with fixed precision and scale. FLOAT, DOUBLE, REAL are approximate.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Which of the following is a valid way to join three tables in SQL?

A. Both A and B

B. SELECT * FROM table1 JOIN table2 ON condition1 JOIN table3 ON condition2;

C. SELECT * FROM table1, table2, table3 WHERE condition1 AND condition2;

D. Neither

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Both syntaxes are valid: explicit JOIN syntax and implicit comma join with WHERE conditions.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs