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

Question

Options

• ADELETE can use a WHERE clause to determine which row(s) should be removed.
• BTRUNCATE can use a WHERE clause to determine which row(s) should be removed.
• CTRUNCATE leaves any indexes on the table in an UNUSABLE state.
• DThe result of a TRUNCATE can be undone by issuing a ROLLBACK.
• EThe result of a DELETE can be undone by issuing a ROLLBACK.

• A
  82% (23)
• B
  11% (3)
• C
  4% (1)
• D
  4% (1)

No community discussion yet for this question.