Examice

Exam 1z0-082 All QuestionsBrowse all questions from this exam

Go to Exam

Question 104

Which two statements are true about the Oracle Data Dictionary? (Choose two.)

All data dictionary view join base tables to dynamic performance views.

Data dictionary base tables can be queried directly.

It is owned by the SYS user.

It is owned by the SYSTEM user.

Data dictionary views are always created with queries that join two or more base tables.

Correct Answer: B, C

The Oracle Data Dictionary is a set of read-only tables that provide information about the database schema and its objects. It is owned by the SYS user, which has administrative privileges in the database. While querying these base tables directly is not recommended, it is technically possible. Therefore, the two correct statements about the Oracle Data Dictionary are that it can be queried directly (although not advisable) and it is owned by the SYS user.

Discussion

ivanadjOptions: BC

https://docs.oracle.com/cd/B10501_01/server.920/a96524/c05dicti.htm

j_tw

I agree that. Data dictionary is owned by SYS user

Oracle2020Options: BC

B, C are correct, because there is no system user, if there is a sys user

Oracle2020

E: false because you can't always join base tables, it can be with views too.

hezzyOptions: BC

BC https://docs.oracle.com/cd/B10500_01/server.920/a96524/c05dicti.htm

auwiaOptions: BC

B and C are corrects.

RaNik69Options: BC

b c are correct