Data Dictionary Question

1) Which of the following statements are true about the data dictionary?
a The data dictionary describes the database and its objects.
b The data dictionary includes two types of objects: base tables, data dictionary views.
c The data dictionary is a set of read-only tables.
d The data dictionary records and verifies information about its associated database.

2)
Base tables are created using the catalog.sql script.
a True
b False

3) Which of the following statements are true about how the data dictionary is used? 

a The Oracle server modifies it when a DML statement is executed.
b It is used to find information about users, schema objects, and storage structures.
c Used by users and DBAs as a read-only reference.
d The data dictionary is a necessary ingredient for the database to function.
 
4) Data dictionary views are static views.
a True
b False
 
5) The information for a Dynamic View is gathered from the control file and data files.
a True
b False
 
6)  Which of the following questions might a Dynamic View answer?
a Is the object online and available?
b What locks are being held?
c Who owns the object?
d What privileges do users have?
e Is the session active?

People who read this post also read :



0 comments:

Post a Comment

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites More