Friday , July 21 2017
Home / Oracle DBA Interview Questions / USER MANAGEMENT INTERVIEW QUESTIONS

USER MANAGEMENT INTERVIEW QUESTIONS

USER MANAGEMENT INTERVIEW QUESTIONS

  1. What is the difference between a user and schema?

    1. A user will not have any of his own objects and will always access others objects. Schema is a collection of objects

  1. After creating user, what are the privileges you would assign?

    1. We will give CONNECT role in 10g (CREATE SESSION if 9i) and any other roles or privileges specified by the application support

  1. What is the disadvantage of resource role?

    1. It will override the quota granted for a user and makes it unlimited

  1. How you will identify the privileges and roles assigned to a user?

    1. Using following views

      1. dba_sys_privs

      2. dba_tab_privs

      3. dba_role_privs

      4. role_sys_privs

      5. role_tab_privs

      6. role_role_privs

  1. How to create user and grant the permission in a single command?

    1. SQL> grant create session to user_a identified by <pwd>;

  1. What happens to the objects if we change the default tablespace for the user?

    1. Nothing. They will continue to work as normal

  1. You got a requirement to run a script as user “MARK” and you don’t have the password of MARK. How you will take next step?

    1. We will ask application support. In case they cannot be reached, we can take ASCII password stored in dba_users and change the password. Once work is done we can change the password back using ASCII that we stored earlier

    2. Also we can set current_user option in SQLPLUS

  1. What is the view to check default permanent and temp tablespace values?

    1. database_properties

  1. Have you implemented password policies?

  2. a. Yes. Using profile management

  1. What are SNIPPED sessions? If there any impact on database to have them?

    1. Those are sessions terminated from database because of crossing IDLE_TIME limit. But disadvantage is even though oracle level sessions are cleared, at OS level processes willstill occupy resources which is a burden to the server

  1. I am using IDLE_TIME as 15 min, but observed that even after 20min idle time, session is not getting disconnected, what is the reason?

    1. RESOURCE_LIMIT parameter is not set to TRUE

  1. As a DBA will you recommend to implement auditing in the database?

    1. Depends on the type of database, but it would be wise to implement atleast on some critical tables

  1. What factors you will choose before you enable auditing?

    1. We need to check about database performance and what level of auditing is required

  1. If auditing is not in place, how you will get to know if a user performed update or not yesterday?

    1. We can use logminer to read the archives which are generated yesterday

  1. Are you maintaining any SOX compliance database?

    1. No. We don’t have any SOX database as of now

  1. How to check which users are granted with sysdba role?

    1. We can check from v$syspw_file view

  1. If we want to restrict users to connect to the database, but want to allow some users to connect, how can we do that?

    1. We need to grant restrcited session privilege for the users whom we want to connect

TABLESPACE INTERVIEW QUESTIONS

Read More:
ORACLE ARCHITECTURE INTERVIEW QUESTIONS
ORACLE BACKUP & RECOVERY
ORACLE DATAPUMP

Comments

comments

Check Also

ORACLE BACKUP and RECOVERY INTERVIEW QUESTIONS

BACKUP & RECOVERY INTERVIEW QUESTIONS 1.What is the difference between cold and hot backup? a.COLD …

Leave a Reply

Your email address will not be published. Required fields are marked *