Which of the following commands is used to completely remove the table and its data?

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?
A . UPDATE
B . DELETE
C . ALTER
D . DROP

View Answer

Answer: D

Explanation:

DROP is the command that is used to completely remove a table and its data from a relational database. DROP is a SQL (Structured Query Language) statement that deletes the definition and contents of a database object, such as a table, index, or view. DROP cannot be undone, so it should be used with caution. For example, the statement DROP TABLE Customers; will delete the table named Customers and all its data from the database.

Reference: The Official CompTIA IT Fundamentals (ITF+) Study Guide (FC0-U61), page 144.