Oracle Exam 1Z0-497 Topic 3 Question 80 Discussion

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

Question #: 80
Topic #: 3

[All 1Z0-497 Questions]

Which two statements describe data dictionary views?

AThey are stored in the SYSTEM tablespace.

BThey are based on virtual tables.

CThey are owned by the SYS user.

DThey speed up query and data manipulation language (DML) operations.

EThe VSFIXED_TABLEview can be queried to list the names of these views.

Show Suggested Answer

Suggested Answer: D

https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038

by Herman at Oct 03, 2023, 01:03 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Yolando

1 months ago

This is easy, B and C are the way to go. Who cares if they speed up queries or not, as long as I get the definitions right!

upvoted 0 times

...

Malika

1 months ago

I'm going with B and E. Virtual tables and the VSFIXED_TABLE view - that's what I remember from my study notes.

upvoted 0 times

Jacinta

16 days ago

Good job remembering that from your study notes. B and E are the correct statements about data dictionary views.

upvoted 0 times

...

Eve

21 days ago

Yes, those are the right choices. Data dictionary views are indeed based on virtual tables and can be queried using VSFIXED_TABLE.

upvoted 0 times

...

Josephine

22 days ago

I think B and E are correct. Virtual tables and VSFIXED_TABLE view are related to data dictionary views.

upvoted 0 times

...

Nenita

2 months ago

I'm not sure about D, but the rest of the options sound right. Maybe the data dictionary views don't actually speed up queries, that seems a bit suspicious.

upvoted 0 times

Kerry

5 days ago

I'm not sure about D, but the rest of the options sound right. Maybe the data dictionary views don't actually speed up queries, that seems a bit suspicious.

upvoted 0 times

...