Oracle Exam 1Z0-071 Topic 5 Question 99 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 99
Topic #: 5

[All 1Z0-071 Questions]

Which two statements are true about truncate and delete?

Athe result of a delete can be undone by issuing a rollback

Bdelete can use a where clause to determine which row(s) should be removed.

CTRUNCATE can use a where clause to determine which row(s) should be removed.

Dtruncate leavers any indexes on the table in an UNUSABLE STATE.

Ethe result of a truncate can be undone by issuing a ROLLBACK.

Show Suggested Answer

Suggested Answer: C, D

by Jin at Aug 03, 2024, 09:23 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

4 days ago

Hmm, D is definitely true. Truncate leaves indexes in an unusable state, which can be a pain to deal with later.

upvoted 0 times

...

5 days ago

I think A and B are the correct answers. Delete allows you to remove specific rows, while truncate removes the entire table contents.

upvoted 0 times

...

18 days ago

I'm not sure about statement C. Can TRUNCATE really use a where clause?

upvoted 0 times

...

21 days ago

I agree with you, Dorcas. But I also believe statement B is true because delete can use a where clause.

upvoted 0 times

...

22 days ago

I think statement A is true because delete can be undone with a rollback.

upvoted 0 times

...