Quiz for TRUNCATE

Q1: What is the difference between DELETE and TRUNCATE?

A. TRUNCATE deletes specific rows B. TRUNCATE is DML C. TRUNCATE removes all rows without logging individual row deletions D. TRUNCATE can use WHERE

Q2: What does the TRUNCATE statement do in SQL?

A. Deletes all rows and logs each row B. Deletes all rows and logs the deallocation of pages C. Deletes specific rows D. Removes the entire table

Q3: Can TRUNCATE be rolled back in a transaction in all RDBMS?

A. Yes B. No C. Only in MySQL D. Depends on DBMS

Q4: Does TRUNCATE fire triggers?

A. Yes B. No C. Only AFTER triggers D. Only BEFORE triggers

Q5: Can you truncate a table referenced by a foreign key?

A. Yes, always B. No C. Only with CASCADE D. Only if FK is NULLABLE

Q6: Which command resets the identity column in SQL Server?

A. DELETE B. DROP C. TRUNCATE D. ALTER

Q7: TRUNCATE is classified under which type of SQL command?

A. DML B. DCL C. TCL D. DDL

Q8: Is TRUNCATE allowed on a table with indexed views in SQL Server?

A. Yes B. No C. Only with hint D. Depends on isolation level

Q9: Which statement is minimally logged in most SQL databases?

A. INSERT B. UPDATE C. DELETE D. TRUNCATE

Q10: Does TRUNCATE free the table’s space?

A. Yes B. No C. Only temp tables D. Only after COMMIT

Q11: Can you use WHERE clause with TRUNCATE?

A. Yes B. No C. Only in MySQL D. Only with subquery

Q12: Which of the following can TRUNCATE not affect?

A. Data pages B. Identity seed C. Constraints D. Column definitions

Q13: Which statement is more resource-intensive?

A. TRUNCATE B. DELETE C. SELECT D. RENAME

Q14: TRUNCATE can be used on which of the following?

A. View B. Table C. Procedure D. Index

Q15: Which statement preserves table structure but removes data?

A. DROP B. DELETE C. TRUNCATE D. ALTER

Q16: In Oracle, can TRUNCATE be undone?

A. Yes B. No C. Only if committed D. Only with backup

Q17: Which of the following does TRUNCATE reset?

A. Table schema B. Constraints C. Auto-increment values D. Column types

Q18: Does TRUNCATE require explicit permissions?

A. Yes B. No C. Only for system tables D. Only on Windows

Q19: TRUNCATE is NOT supported in which SQL operation?

A. Subquery B. Join C. Nested transactions D. Views

Q20: Which is true about TRUNCATE and DELETE?

A. Both are DML B. TRUNCATE is DDL, DELETE is DML C. Both fire triggers D. DELETE is faster