A database administrator needs to remove a redundant customer table from a database in order to streamline periodic reports. Which of the following commands is best for this task?

The correct answer is D. DROP TABLE CUSTOMER. DROP TABLE CUSTOMER is the correct SQL command for permanently removing an entire table and all its data from a database schema. DELETE is a DML command used to remove rows from a table, not the table itself - and it requires a valid syntax like DELETE FROM table. UPDATE modifies

Database Management and Maintenance

Question

Options

ADELETE TABLE CUSTOMER
BUPDATE TABLE CUSTOMER
CREMOVE TABLE CUSTOMER
DDROP TABLE CUSTOMER

How the community answered

(19 responses)

A
5% (1)
C
11% (2)
D
84% (16)

Explanation

DROP TABLE CUSTOMER is the correct SQL command for permanently removing an entire table and all its data from a database schema. DELETE is a DML command used to remove rows from a table, not the table itself - and it requires a valid syntax like DELETE FROM table. UPDATE modifies existing row data and has nothing to do with table removal. REMOVE is simply not a valid SQL command.

Memory tip: Think "DROP = destroy the structure." If you're cleaning up the schema (the table itself), DROP is your tool. If you're cleaning up data inside a table, use DELETE.

Topics

#DROP TABLE#DDL#Schema Management#Table Removal

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice