What are the roles and user accounts created automatically
with the database ?
Answer / guest
DBA - role Contains all database system privileges.
SYS user account - The DBA role will be assigned to this
account. All of the basetables and views for the
database's dictionary are store in this schema and are
manipulated only by ORACLE.
SYSTEM user account - It has all the system privileges for
the database and additional tables and views that
display administrative information and internal tables and
views used by oracle tools are created using this username.
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the responsibilities of a Database Administrator ?
How can you Enforce Refrencial Integrity in snapshots ?
What are the dictionary tables used to monitor a database spaces ?
What are the system resources that can be controlled through Profile ?
What is user Account in Oracle database ?
What are the use of Roles ?
What is Auditing ?
How to prevent unauthorized use of privileges granted to a Role ?
what is the step for rmanbackup?
What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?
what is different between view and sequence?
How can you enable automatic archiving ?