Multiple choice technology programming languages

The TRUNCATE TABLE…

  1. checks if the table has primary key specified

  2. Deletes the table

  3. deletes all rows from a table

  4. change the structure of the table

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

TRUNCATE TABLE is a DDL operation that quickly removes all rows from a table by deallocating data pages, unlike DELETE which is a DML operation that logs row-by-row deletions. The table structure, indexes, and constraints remain intact; only the data is removed.