Multiple choice

The Truncate Table statement when issued, _____.

  1. deletes all the records from a table

  2. deletes all the rows along with the table

  3. deletes the structure of the table leaving rows intact

  4. deletes only the null rows of a table
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Truncate Table statement is used to delete all the rows of a table at once. The statement allows the user to delete all the records without specifying a condition using the where clause. Truncate  deletes all the records but keeps the structure of the table intact. The output of this statement is equivalent to the delete statement without the where statement.

Keep practicing — related questions