Which command is used to remove a relation from an SQL?

  • A. a) Drop table
  • B. b) Delete
  • C. c) Purge
  • D. d) Remove
Correct Answer: A. a) Drop table
DROP TABLE is the SQL command used to remove an entire relation (table) from a database.

Here's a breakdown of why the other options are incorrect:

DELETE: This command removes rows (tuples) from a table, but it doesn't remove the table itself.

PURGE: This command is not a standard SQL command. It might exist in specific database systems with particular functionalities, but it's not generally used for removing tables.

REMOVE: This is also not a standard SQL command for removing tables.

So, DROP TABLE is the correct choice for permanently deleting a table from a database.

If you think there is any confusion in the given MCQs, you can comment below.

Follow us on WhatsApp

docmcqs.com is Pakistan's No.1 online platform for preparing for all types of exams including PPSC, FPSC, KPSC, SPSC, Ministry of Defence, and for one-paper MCQs. This includes Pedagogy MCQs, general knowledge MCQs, current affairs MCQs, and much more.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top