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 10 Question 111 Discussion

Actual exam question for Oracle's 1Z0-071 exam
Question #: 111
Topic #: 10
[All 1Z0-071 Questions]

Which two statements are true about dropping views?

Show Suggested Answer Hide Answer
Suggested Answer: A, D

by Micaela at Jan 22, 2025, 11:49 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Kyoko
2 months ago
This is a tricky one. I think I'll go with A, D, and E. Gotta cover all the bases on this certification exam!
upvoted 0 times
...
Rima
2 months ago
Haha, I bet the answer is just C to mess with us. Delete the data in the underlying tables? That's just cruel!
upvoted 0 times
Lindsey
19 days ago
D) The creator of a view to be dropped must have the drop any view privilege.
upvoted 0 times
...
Bernardo
22 days ago
C) Data selected by a view's defining query is deleted from its underlying tables when the view is dropped.
upvoted 0 times
...
Bev
1 months ago
B) Read only views cannot be dropped.
upvoted 0 times
...
Amira
1 months ago
A) Views referencing a dropped view become invalid.
upvoted 0 times
...
...
Ryan
2 months ago
I'm going with B and E. Read-only views can't be dropped, and you'd definitely need to cascade constraints if other objects reference the view's keys.
upvoted 0 times
Evelynn
16 days ago
No problem, happy to help!
upvoted 0 times
...
Junita
28 days ago
Good to know, thanks for the info.
upvoted 0 times
...
Tran
1 months ago
Yes, that's correct. And you also need to specify CASCADE CONSTRAINTS if other objects reference the view's keys.
upvoted 0 times
...
Shawna
1 months ago
I think you're right, read-only views cannot be dropped.
upvoted 0 times
...
...
Nicolette
2 months ago
I'm not sure, but I think B is definitely false.
upvoted 0 times
...
Gail
2 months ago
I disagree, I believe it's C and E.
upvoted 0 times
...
Shalon
2 months ago
I think A and D are true.
upvoted 0 times
...
Paris
2 months ago
A and D seem like the most logical choices here. Views are just virtual tables, so of course referencing ones that are dropped would become invalid. And the creator would need the right privileges to drop a view.
upvoted 0 times
Buffy
2 months ago
Yes, those are the most logical choices for dropping views.
upvoted 0 times
...
Eveline
2 months ago
I agree, A and D are the correct statements.
upvoted 0 times
...
...

Save Cancel