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?

The correct answer is D. DROP. 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

Database Fundamentals

Question

Options

AUPDATE
BDELETE
CALTER
DDROP

How the community answered

(28 responses)

A
4% (1)
C
4% (1)
D
93% (26)

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.

Topics

#SQL#DDL#DROP TABLE#relational database

Community Discussion

No community discussion yet for this question.

Full FC0-U61 Practice