Which two statements are true about TRUNCATE and DELETE? (Choose two.)
Posted: Sun Jun 11, 2023 3:54 pm
Which two statements are true about TRUNCATE and DELETE? (Choose two.)
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.
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.