CompTIA ITF+ (FC0-U61) — Question 62

A database administrator finds that a table is not needed in a relational database. Which of the following commands is used to completely remove the table and its data?

Answer options

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

Correct answer: D

Explanation

The correct command to completely remove a table and all its associated data is DROP, as it deletes the table structure itself. The UPDATE command modifies existing records, DELETE removes records but keeps the table, and ALTER changes the structure of the table without removing it.