Which two statements are true? (Choose two.)
A.
The USER_SYNONYMS view can provide information about private synonyms.
B.
The user SYSTEM owns all the base tables and user-accessible views of the data dictionary.
C.
All the dynamic performance views prefixed with V$ are accessible to all the database users.
D.
The USER_OBJECTS view can provide information about the tables and views created by the user only.
E.
DICTIONARY is a view that contains the names of all the data dictionary views that the user can access.
why are A, E correct? But not B, D???
SYS:
automatically created when Oracle database is installed granted the DBA role
owns the base tables and views for the database data dictionary
the default schema when you connect as SYSDBA
Tables in the SYS schema are manipulated only by the database.
SYSTEM:
automatically created
automatically granted the DBA role
has a default password: MANAGER (make sure you change it)
used to create additional tables and views that display administrative information
used to create internal tables and views used by various Oracle database options and tools
Dynamic performance views are continuously updated while a database is open and in use, and their contents relate primarily to performance. ONLY simple SELECT statement on Dynamic views.
The actual dynamic performance views are identified by the prefix V_$.
Public synonyms for these views have the prefix V$. Database administrators and other users should access only the V$ objects, not the V_$ objects.
so C is wrong
USER_OBJECTS describes all objects owned by the current user not only tables and views.
C,D,E
A,E
AE
Very informative article post. Will read on…