Size of storage disk is not provided by data dictionary - Database

Q.  What information is not provided by a data dictionary?
- Published on 27 Aug 15

a. How data is used
b. Where data is located
c. Size of storage disk
d. Who owns or is responsible for data

ANSWER: Size of storage disk
 

    Discussion

  • Nirja Shah   -Posted on 30 Oct 15
    Structure of the Data Dictionary

    - The data dictionary consists of the following:

    Base Tables
    - The underlying tables that store information about the associated database.
    - Only Oracle should write to and read these tables.
    - Users rarely access them directly because they are normalized, and most of the data is stored in a cryptic format.

    User-Accessible Views
    - The views that summarize and display the information stored in the base tables of the data dictionary.
    - These views decode the base table data into useful information, such as user or table names, using joins and WHERE clauses to simplify the information.
    - Most users are given access to the views rather than the base tables.

    SYS, Owner of the Data Dictionary
    - The Oracle user SYS owns all base tables and user-accessible views of the data dictionary.
    - No Oracle 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.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)