Home » MCQs » SQL MCQs » SQL Commands: DDL, DML, DCL, TCL, DQL MCQs

Which command will remove the records from the table, but not affect the structure of the table?

17. Which command will remove the records from the table, but not affect the structure of the table?

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

Answer: B) DELETE

Explanation:

The TRUNCATE command will remove the records from the table, but not affect the structure of the table.