Oracle Database SQL — Question 261

Which two statements are true about TRUNCATE and DELETE? (Choose two.)

Answer options

• A. DELETE can use a WHERE clause to determine which row(s) should be removed.
• B. TRUNCATE can use a WHERE clause to determine which row(s) should be removed.
• C. TRUNCATE leaves any indexes on the table in an UNUSABLE state.
• D. The result of a TRUNCATE can be undone by issuing a ROLLBACK.
• E. The result of a DELETE can be undone by issuing a ROLLBACK.

Correct answer: A, E

Explanation

Option A is correct because DELETE allows for the use of a WHERE clause to target specific rows for removal. Option E is also correct since DELETE operations can be reversed with a ROLLBACK. In contrast, TRUNCATE does not permit a WHERE clause (B), it does not leave indexes in an UNUSABLE state (C), and TRUNCATE operations cannot be rolled back (D).