Database Fundamentals — Question 45

You need to delete a database table.
Which data definition language (DDL) keyword should you use?

Answer options

• A. ALTER
• B. DELETE
• C. DROP
• D. TRUNCATE

Correct answer: C

Explanation

The correct answer is C, DROP, which is specifically used to remove database objects like tables. The ALTER keyword is used to modify existing tables, DELETE is for removing rows from a table, and TRUNCATE is used to delete all rows while keeping the table structure intact.