Multiple choice technology databases

TRUNCATE IS USED TO?

  1. DROP TABLE

  2. DELETE ALL ROWS

  3. DELETE ALL COLUMNS

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

TRUNCATE is a DDL command that removes all rows from a table while keeping the table structure intact. Unlike DELETE (which is DML and can be rolled back), TRUNCATE deallocates data pages, making it faster for clearing large tables. It does not drop the table itself, delete columns, or affect the database software.

Keep practicing — related questions