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.)
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Which two statements are true about TRUNCATE and DELETE? (Choose two.)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!