Multiple choice

Which of the following is a DDL command?

  1. INSERT

  2. TRUNCATE

  3. UPDATE

  4. DELETE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This answer is correct. TRUNCATE statement is a DDL (Data Definition Language) statement but not a DML (Data Manipulation Language) statement. TRUNCATE statement when executed will remove all rows from the given table and will automatically commit the transaction.

Keep practicing — related questions