Oracle Exam 1Z0-071 Topic 15 Question 71 Discussion

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

Question #: 71
Topic #: 15

[All 1Z0-071 Questions]

Which two statements are true about the data dictionary?

AViews with the prefix dba_ display only metadata for objects in the SYS schema.

BViews with the prefix all_ display metadata for objects to which the current user has access.

CThe data dictionary is accessible when the database is closed.

DViews with the prefix all_, dba_ and useb_ are not all available for every type of metadata.

EThe data dictionary does not store metadata in tables.

Show Suggested Answer

Suggested Answer: D, E

by Quentin at Feb 24, 2023, 01:44 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Cheryl

1 days ago

This is a tricky one. I'm going to go with B and D. The all_ views are my go-to, but the other prefixes can be useful too. As for the data dictionary not storing metadata in tables - that's just plain silly!

upvoted 0 times

...

Amie

10 days ago

I'm pretty sure C is false. The data dictionary is like the brain of the database - it's always up and running, even when the database is shut down.

upvoted 0 times

Lindsey

4 hours ago

A) Views with the prefix dba_ display only metadata for objects in the SYS schema.

upvoted 0 times

...

Patrick

21 days ago

I'm not sure about option D. Can someone explain why views with the prefix all_, dba_, and user_ are not available for every type of metadata?

upvoted 0 times

...

Xochitl

23 days ago

Hmm, I think B and D are the correct answers. The data dictionary is a treasure trove of information, but you've got to know how to navigate it.

upvoted 0 times

Linn

1 days ago

I agree, B and D are the correct answers.

upvoted 0 times

...

Arthur

23 days ago

I agree with you, Antonio. Views with the prefix all_ show metadata for objects the user has access to, and not all views are available for every type of metadata.

upvoted 0 times

...

Antonio

1 months ago

I think the correct answers are B and D.

upvoted 0 times

...