My photo by Pragati S

HP Emphasis Bangalore (Shankar)

1.       Describe about yourself , your past experience.

2.       How you will rate yourself for RAC on a scale of 1 to 10.

3.       How you will rate yourself for Data guard on a scale of 1 to 10.

4.       How you will rate yourself for oracle DBA on a scale of 1 to 10.

5.       While implementation of RAC, how SSS (Secured Socket Shell) is being configured. What are the steps.

6.       How dataguard is being implemented. Concept of dataguard.

7.       How you will rate yourself in backup and recovery on a scale of 1 to 10.

8.       One scenario – Archive log DB – every Monday backup of DB is taken at 8 am. Today offline backup is taken due to H/w maintenance. After 2/3 hrs DB got crashed due to h/w electric failure.  Now how you will do point in recovery.  Tell me command to do point in time recovery.

Faqs from1 – 21 pages  

HP Bangalore / Chennai 1 march 2010

1.        How many databases you support. What is the platform? Are you familiar with windows environment?

Two databases I support and size is 400 GB, Linux / oracle 9i. Yes, I am familiar with windows environment.

2.        Are you comfortable working with data guard?

      Yes, I am comfortable working with data guard.

3.        You are working on two databases; it has two nodes, if you want that some users get connected to Node A and some users get connected to Node B. Both Nodes are on same servers.

I will give the path (URL), so that some users are connected to Node A and similarly some users are connected to Node B.

4.        Tell me any wait events that you have worked with?

      V$event_name (i) Buffer busy wait event

                                (ii) Log file switch event 

       V$session_event

       V$session_wait

5.        I have a redo log that is corrupted and how will I get repair / rectify the redo log?

I will rollback to a previous transaction. I will create a redo log of bigger size and I will do log switch and when the present redo becomes deactive and the new redo log becomes active then I will delete the old redo log.

If the redo log is corrupted then I will not be able to do a log switch. In such scenario, I have to rollback the old redo log to a previous transaction.

6. There are certain blocks that are corrupted? How will I rectify the corrupted                                                                                                 blocks?

I will use this view V$block_corruption and then I will come to know which    blocks are corrupted and then I will rectify the corrupted blocks.

This is the rman setup that you talking about, if rman setup is not there, how you will rectify the corrupted blocks.

7.  Are you familiar with ITIL certification? Are you aware with the concepts?

8. One client has got the problem the computer is working slowly? How will you rectify the problem?

I will login through remotely through remote desktop connection- I will delete cookies, fragmentation wizard – data is consolidated at one location.

1.    Tell me any wait event that you have worked.

Wait event queue – It means that certain processes that are running are time consuming. Processes are waiting for certain resources to get free.

2.    What you infer by Oracle Inventory and where it is located.