Database Administrator (DBA) Question:
Download Job Interview Questions and Answers PDF
What are the roles and user accounts created automatically with the database?
Answer:
DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the base tables 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.
Download Database Administrator (DBA) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What are the dictionary tables used to monitor a database spaces? | What are the minimum parameters should exist in the parameter file (init.ora)? |