Which statements are true? (Choose all that apply.)
A.
The data dictionary is created and maintained by the database administrator.
B.
The data dictionary views can consist of joins of dictionary base tables and user-defined tables.
C.
The usernames of all the users including the database administrators are stored in the data dictionary.
D.
The USER_CONS_COLUMNS view should be queried to find the names of the columns to which a constraint applies.
E.
Both USER_OBJECTS and CAT views provide the same information about all the objects that are owned by the user.
F.
Views with the same name but different prefixes, such as DBA, ALL and USER, use the same base tables from the data dictionary
Data dictionary is updated automatically and maintained by the Oracle.
DD keeps tracks of all users in the database (Which account owns the objects, privileges, status). CAT (only TABLE NAME and TYPE) and USER_OBJECTS ( OBJECT NAME and OBJECT TYPE, last DDL time, timestamp) provide different information on db objects.
select * from CAT;
select * from USER_OBJECTS;
data dictionary : a read-only set of tables that provides information about the database. A data dictionary contains:
The definitions of all schema objects in the database (tables, views, indexes, clusters, synonyms, sequences, procedures, functions, packages, triggers, and so on)
How much space has been allocated for, and is currently used by, the schema objects
Default values for columns
Integrity constraint
The names of Oracle users
Privileges and roles each user has been granted
data dictionary contains metadata about database…
It has:
The definitions of every schema object ( default values for columns and integrity constraint, data type_
The amount of space allocated for objects
The names of Oracle Database users, privileges and roles granted to users
CDF