Oracle dba Interview at HP Company

Attended F2F Interview at Client  Hp Company

By Payroll Company www.netconnectglobal.com

2+ experience

1ow many databases you are managing

2.how many servers you managing

3.Size of your database

4.On which project you are working ?

5.Explain Oracle Architecture

6.What SMON and PMON do ?

7.What is the use of  Checkpoint ?

8.What does Control File Contains ?

9.How select Statement works

10.How Update Statement works

11.which process writes from datafiles to dbbc ?

12.which writer writes from dbbc to datafiles ?

13.11g new features

14.use of logswitch and scn

15.what u do if u lost all control files 

16.Suddenly one of datafile db01.dbf became unnamed00001.dbf then what u do ?

17.Additional Parameters for standby database ?

18.What are Modes in Dataguard and Explain it 

19.How will you recover if u lost user datafile ?

20.Use of Undo Tablespace

21.Difference Between Normal Export and Datapump Export ?

22.How do u stop and start a Datapump Job ?


Please send Documents to kumarbobby143@gmail.com if you attended any Interview

So,I can upload it in this blog , it will be useful to us and others

Thank Yoy