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|
How can we specify the Archived log file name format and destination ?
What is Object Auditing ?
What is the use of ANALYZE command ?
what is snapshot log ?
When will the data in the snapshot log be used ?
What are the use of Roles ?
How will you enforce security using stored procedures ?
What are roles ? How can we implement roles ?
What is a trace file and how is it created ?
What are the roles and user accounts created automatically with the database ?
What are the responsibilities of a Database Administrator ?
Differentiate simple and complex, snapshots ?