Tables in Tables schema cannot be redefined - Oracle Tables

Q.  Which tables in the Tables schema cannot be redefined?
- Published on 27 Jul 15

a. SYS
b. SYSTEM
c. Both A & B
d. None of the above

ANSWER: Both A & B
 

    Discussion

  • Nirja Shah   -Posted on 01 Sep 15
    - The following administrative user accounts are automatically created when you install Oracle Database Express Edition (Oracle Database XE).

    - They are both created with the password that you supplied upon installation (Windows operating systems) or configuration (Linux operating systems).

    - SYSTEM
    - This is the user account that you log in with to perform all administrative functions other than starting up and shutting down the database.

    - SYS
    - All base tables and views for the database data dictionary are stored in the SYS schema.
    - These base tables and views are critical for the operation of Oracle Database XE.
    - To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by the database.
    - They should never be modified by any user or database administrator.
    - You must not create any tables in the SYS schema.

    - There is typically no reason to log in as user SYS.

    - User SYSTEM is preferred for all administrative tasks except starting up and shutting down.

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.)