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 steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?
How can you enable automatic archiving ?
What are roles ? How can we implement roles ?
What is Object Auditing ?
What are the system resources that can be controlled through Profile ?
What are the dictionary tables used to monitor a database spaces ?
How can we specify the Archived log file name format and destination ?
When will the data in the snapshot log be used ?
How will you enforce security using stored procedures ?
What is a profile ?
What is Privilege Auditing ?
Differentiate simple and complex, snapshots ?