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

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jerry

30 days ago

I'm pretty sure C is wrong, truncate doesn't use a where clause. It's like a nuclear option for the entire table. *laughs* Gotta be careful with that one!

upvoted 0 times

...

Shaquana

1 months ago

E is incorrect, the result of a truncate cannot be undone with a rollback. That's just common sense, right? *chuckles*

upvoted 0 times

Reynalda

5 days ago

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

upvoted 0 times

...

Clarence

19 days ago

A) the result of a delete can be undone by issuing a rollback

upvoted 0 times

...

Van

2 months 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

Lavonna

15 days ago

D) truncate leavers any indexes on the table in an UNUSABLE STATE.

upvoted 0 times

...

Tennie

25 days ago

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

upvoted 0 times

...

Delsie

1 months ago

A) the result of a delete can be undone by issuing a rollback

upvoted 0 times

...

Evangelina

2 months 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

Judy

18 days ago

Truncate removes the entire table contents and leaves any indexes on the table in an UNUSABLE STATE.

upvoted 0 times

...

Margarett

1 months ago

That's true, the result of a delete can be undone by issuing a rollback.

upvoted 0 times

...

Cristen

1 months ago

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

upvoted 0 times

...

Elizabeth

2 months ago

I think A and B are the correct answers.

upvoted 0 times

...

Margurite

2 months ago

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

upvoted 0 times

...

Leatha

2 months ago

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

upvoted 0 times

...

Dorcas

2 months ago

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

upvoted 0 times

...