- A TRUNCATE TABLE deletes the table structure and its data.
- B TRUNCATE TABLE removes the table structure but preserves its data.
- C TRUNCATE TABLE only removes the data from a table.
- D TRUNCATE TABLE is not a valid statement in MySQL.
- Share this MCQ
Answer:
A
Share this MCQ
The TRUNCATE TABLE statement in MySQL is used to delete all data from a table while preserving the table structure. It is a faster alternative to the DELETE statement for removing all rows from a table.
Click me to Read more Question & Answer of Data definition language - MySQLShare this MCQ