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

Question Report Error

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

A. DELETE

B. DROP

C. TRUNCATE

D. REMOVE

Answer: Option B

Solution (By JKExamLibrary)

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)

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

Who proposed the relational database model based on mathematical relation theory in 1970?

A. Dennis Ritchie

B. James Gosling

C. E.F. Codd

D. Charles Bachman

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Dr. Edgar Frank Codd (E.F. Codd) invented the relational model for database management while working for IBM in 1970.

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

Question #2 Report Error

Which clause is used in a SQL SELECT statement to organize matching rows into summary groups based on one or more columns?

A. ORDER BY

B. SORT BY

C. HAVING

D. GROUP BY

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
The GROUP BY clause groups rows that have the same values into summary rows, often used alongside aggregate functions like COUNT(), MAX(), or AVG().

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

Question #3 Report Error

Which clause is used in SQL queries to filter rows and retrieve only those records that satisfy a specific condition?

A. GROUP BY

B. ORDER BY

C. HAVING

D. WHERE

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
The WHERE clause is used to filter records based on a specified condition before any grouping takes place.

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

Explore All Database Management System (DBMS) MCQs