DS0-001: CompTIA DataSys+Demo

Question

A database administrator must remove a redundant customer table from a database to streamline periodic reports. Which command is best for this task?

A DELETE TABLE CUSTOMER
B UPDATE TABLE CUSTOMER
C REMOVE TABLE CUSTOMER
D DROP TABLE CUSTOMER

Explanation

DROP TABLE CUSTOMER removes the CUSTOMER table itself from the database, including its definition and data. DELETE would only remove rows while leaving the table in place.

DS0-001: CompTIA DataSys+Demo

AstroTutor

Notes

Readiness

QuestionQ89

Community Discussion