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.
Which two statements are true about TRUNCATE and DELETE? (Choose two.)
-
- Site Admin
- Posts: 899566
- Joined: Mon Aug 02, 2021 8:13 am