Question

To remove a relation from an SQL database, we use the ______ command.

(a) Delete

(b) Purge

(c) Remove

(d) Drop table

I got this question in a national level competition.

This interesting question is from SQL Basics and SQL Data Definition in section SQL : Queries, Constraints and Triggers of Database Management

Answer 1

Correct answer is (d) Drop table

The explanation is: Drop table deletes the whole structure of the relation .purge removes the table which cannot be obtained again.