Which statements listed below describe the data dictionary views?
1. These are stored in the SYSTEM tablespace
2. These are the based on the virtual tables
3. These are owned by the SYS user
4. These ban be queried by a normal user only if O7_DICTIONARY_ACCESSIBLILITY parameter is set
to TURE
5. The V$FIXED_TABLE view can be queried to list the names of these views
A.
1 and 3
B.
2,3 and 5
C.
1,2, and 5
D.
2,3,4 and 5
SYS, Owner of the Data Dictionary
The Oracle Database user SYS owns all base tables and user-accessible views of the data dictionary. No Oracle Database user should ever alter (UPDATE, DELETE, or INSERT) any rows or schema objects contained in the SYS schema, because such activity can compromise data integrity. The security administrator must keep strict control of this central account.
All the data dictionary tables and views for a given database are stored in that database’s SYSTEM tablespace.
V$FIXED_TABLE
This view displays all dynamic performance tables, views, and derived tables in the database. Some V$ tables (for example, V$ROLLNAME) refer to real tables and are therefore not listed.
1,3 They are owned and stored in system tablespace & sys user.
2. The dynamic performance views based memory structures within the database server to build a virtual table based.
4. Enable data dictionary protection using O7_DICTIONARY_ACCESSIBILTY parameter is set to false, prevents ordinary users from accessing the data dictionary.
5.V $ FIXED_TABLE only query kinetic performance view all the names.