Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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?

Show Suggested Answer Hide 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
2 months 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
2 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
Haydee
14 days 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
...
Kate
26 days ago
D) truncate leavers any indexes on the table in an UNUSABLE STATE.
upvoted 0 times
...
Reynalda
1 months ago
B) delete can use a where clause to determine which row(s) should be removed.
upvoted 0 times
...
Clarence
2 months ago
A) the result of a delete can be undone by issuing a rollback
upvoted 0 times
...
...
Van
3 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
1 months ago
D) truncate leavers any indexes on the table in an UNUSABLE STATE.
upvoted 0 times
...
Tennie
2 months ago
B) delete can use a where clause to determine which row(s) should be removed.
upvoted 0 times
...
Delsie
2 months ago
A) the result of a delete can be undone by issuing a rollback
upvoted 0 times
...
...
Evangelina
3 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
2 months ago
Truncate removes the entire table contents and leaves any indexes on the table in an UNUSABLE STATE.
upvoted 0 times
...
Margarett
2 months ago
That's true, the result of a delete can be undone by issuing a rollback.
upvoted 0 times
...
Cristen
2 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
3 months ago
I'm not sure about statement C. Can TRUNCATE really use a where clause?
upvoted 0 times
...
Leatha
3 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
3 months ago
I think statement A is true because delete can be undone with a rollback.
upvoted 0 times
...

Save Cancel