technology medium mcq

Which SQL command is used to remove a table and all its data permanently from the database?

  1. DELETE
  2. TRUNCATE
  3. DROP
  4. REMOVE

Answer: DROP

DROP TABLE removes the entire table structure and all data permanently; cannot be rolled back in most systems. DELETE removes rows (can use WHERE, can be rolled back). TRUNCATE removes all rows quickly but keeps table structure. DROP is a DDL command; DELETE/TRUNCATE are DML commands.

Topic Database & Programming
Exam Relevance Banking, SSC JE, Railway

More Technology Questions