What are the roles and user accounts created aut

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

220. What are the roles and user accounts created automatically with the database?

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.

(Continued on next question...)

Other Job Interview Questions

• Give the reasoning behind using an index.
• What are the different styles of activation of ole Objects?
• Describe two phases of Two-phase commit?
• What are three panes that appear in the run time pl/SQL interpreter?
• Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?
• How can you determine if an index needs to be dropped and rebuilt?
• What type of index should you use on a fact table?
• At what point of report execution is the before Report trigger fired?
• When creating a user, what permissions must you grant to allow them to connect to the database?
• What other parts of your organization do you interact with and how?
• More...