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 system resources that can be controlled through Profile ?
How to prevent unauthorized use of privileges granted to a Role ?
What is Tablespace Quota ?
How will you enforce security using stored procedures ?
How can you enable automatic archiving ?
What are Roles ?
What is Auditing ?
what is snapshot log ?
How can we specify the Archived log file name format and destination ?
What are the benefits of distributed options in databases ?
what is meant by physical order and logical order in clustered index and non clustered index.
What is Privilege Auditing ?