When an Oracle database is created, which user is automatically created and granted the DBA role?

Options
- SYS
- SYSTEM
- SGA
- Both a and b

CORRECT ANSWER : Both a and b

Discussion Board
SYS and SYSTEM

Two administrative user accounts are automatically created when Oracle Database is installed:
1. SYS
2. SYSTEM

1. SYS: All of the base tables and views for the database data dictionary are stored in the schema SYS. These base tables and views are critical for the operation of Oracle Database. To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by the database. hey should never be modified by any user or database administrator, and no one should create any tables in the schema of user SYS (However, you can change the storage parameters of the data dictionary settings if necessary). Ensure that most database users are never able to connect to Oracle Database using the SYS account.

2. SYSTEM: The SYSTEM username is used to create additional tables and views that display administrative information, and internal tables and views used by various Oracle Database options and tools. Never use the SYSTEM schema to store tables of interest to non-administrative users.

Prajakta Pandit 02-14-2017 12:50 AM

Write your comments


Enter the code shown above:

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


Related Content

Advertisement
 
▲