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 1Z0-071 Exam - 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:

0/2000 characters
Submit Cancel
Queenie
4 months ago
E seems off, I thought truncate couldn't be rolled back?
upvoted 0 times
...
Bong
4 months ago
D is misleading, truncate doesn't leave indexes unusable.
upvoted 0 times
...
Rebeca
4 months ago
Wait, C is false, truncate can't use a where clause.
upvoted 0 times
...
Tracie
5 months ago
Totally agree, B is also correct!
upvoted 0 times
...
Mari
5 months ago
A is true, you can rollback a delete.
upvoted 0 times
...
Laurel
5 months ago
I definitely recall that truncate can't be rolled back, but I can't remember if it affects indexes or not.
upvoted 0 times
...
Becky
5 months ago
I'm a bit confused about truncate and its effect on indexes. I feel like it doesn't leave them unusable, but I could be wrong.
upvoted 0 times
...
Eladia
5 months ago
I practiced a question like this, and I think delete is the only one that can use a where clause.
upvoted 0 times
...
Lacey
5 months ago
I remember that delete can be rolled back, but I'm not sure about truncate. I think it can't be undone.
upvoted 0 times
...
Lenna
5 months ago
Okay, let me think this through step-by-step. I know that delete allows you to remove specific rows based on a WHERE clause, but truncate just removes all the data from the table. I'm pretty sure truncate doesn't leave indexes in an unusable state, but I'm not 100% certain on that. I'll make my best guess and move on.
upvoted 0 times
...
Shawnta
5 months ago
Hmm, this is a tricky one. I remember that truncate is different from delete in some key ways, but I can't quite recall the details. I'll need to review my notes on the differences between the two commands before answering.
upvoted 0 times
...
Jacob
6 months ago
I'm pretty confident about this one. I know that delete can use a WHERE clause, and that the results of a delete can be undone with a rollback. I'm not sure about the truncate statements though, so I'll have to think those through carefully.
upvoted 0 times
...
Ivette
6 months ago
This question seems straightforward, but I want to be sure I don't miss anything. I'm confident that delete can use a WHERE clause, and that the results of a delete can be rolled back. As for truncate, I believe it removes all the data from the table without leaving indexes in an unusable state, but I'll double-check that before submitting my answer.
upvoted 0 times
...
Anna
6 months ago
Hmm, I'm a bit unsure about this one. I'll need to think it through step-by-step to make sure I understand the implications of each option.
upvoted 0 times
...
Jerry
10 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
10 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
9 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
...
Kate
9 months ago
D) truncate leavers any indexes on the table in an UNUSABLE STATE.
upvoted 0 times
...
Reynalda
9 months ago
B) delete can use a where clause to determine which row(s) should be removed.
upvoted 0 times
...
Clarence
10 months ago
A) the result of a delete can be undone by issuing a rollback
upvoted 0 times
...
...
Van
11 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
10 months ago
D) truncate leavers any indexes on the table in an UNUSABLE STATE.
upvoted 0 times
...
Tennie
10 months ago
B) delete can use a where clause to determine which row(s) should be removed.
upvoted 0 times
...
Delsie
10 months ago
A) the result of a delete can be undone by issuing a rollback
upvoted 0 times
...
...
Evangelina
11 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
10 months ago
Truncate removes the entire table contents and leaves any indexes on the table in an UNUSABLE STATE.
upvoted 0 times
...
Margarett
10 months ago
That's true, the result of a delete can be undone by issuing a rollback.
upvoted 0 times
...
Cristen
10 months ago
Yes, delete can use a where clause to determine which row(s) should be removed.
upvoted 0 times
...
Elizabeth
11 months ago
I think A and B are the correct answers.
upvoted 0 times
...
...
Margurite
11 months ago
I'm not sure about statement C. Can TRUNCATE really use a where clause?
upvoted 0 times
...
Leatha
12 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
12 months ago
I think statement A is true because delete can be undone with a rollback.
upvoted 0 times
...

Save Cancel