Tables in Tables schema cannot be redefined - Oracle Tables
Oracle (MCQ) questions and answers
Q. Which tables in the Tables schema cannot be redefined?
- Published on 27 Jul 15
Both A & B
None of the above
ANSWER: Both A & B
Oracle DBA (
Oracle Replication (
Oracle Architecture (
Oracle Transaction (
Administering and Managing an Oracle Database (
Managing Oracle Database Processes (
Oracle Control Files (
Oracle Redo Log (
Oracle Tablespaces (
Oracle Datafiles and Tempfiles (
Oracle Managed Files (
Oracle Schema (
Oracle Tables (
Oracle Indexes and Partitioned Tables (
Oracle Clusters (
Oracle Views, Sequences, and Synonyms (
Oracle Distributed Database concepts (
-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).
- This is the user account that you log in with to perform all administrative functions other than starting up and shutting down the database.
- 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.)