Home » MCQs » SQL MCQs » SQL Basics (Set 2) MCQs

What does the TRUNCATE TABLE Statement do?

14. What does the TRUNCATE TABLE Statement do?

1. In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
2. In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
3. By executing this SQL statement, all records in the SQL database will be deleted.
4. The data specified in this table or view is reported in this SQL statement.

Answer: C) By executing this SQL statement, all records in the SQL database will be deleted

Explanation:

By executing TRUNCATE TABLE SQL statement, all records in the SQL database will be deleted.