Oracle DBA Interview Questions

#COMPANY- Oracle (OFSS), Location -Bangalore

1. Describe oracle architecture.
2. What is the role of PMON process?
3. What are the stages of Databsase startup process?
4. What is the backup process in your current organization?
5. How do you restore DB from avaialble backup? Describe with steps.
6. What is LMT & DMT?
7.There is a GAP of 1000 archives in my standby. How will you resolve it?
8.There is a GAP of only 2-3 archives in my standby.what is the action you will take to check?
9.Archives are not arriving at the standby. What will you check?
10.Difference between Data dictinoary Table and normal Table?
11. What will happen when we hit startup Upgrade?
12. Describe few steps of Oracle DB Upgrade?
13 How you are doing Oracle Binaries Installtion? what kernel parameter you are setting before Installtion?Name Please.
14.What are stwps for configuring Oracle Dataguard/ physical standby?
15.How you will check directory size in ASM?

——————————–
#COMPANY-INFOSYS, Location -PAN
——————————–
1.What is Database?
2.What is deadlock? Describe the deadlock situation.
3.Describe the Table level lock.
4.What is RAC?only defination.
5.What is cause of DB slowness? Atleast 5 points.

———————————————-
#COMPANY-ACCENTURE INDIA, Location- Kolkata WB
———————————————-
1.Describe oracle architecture.
2.What are the parameter file present on DB?
3.What is oratab file?
4. How to check version of Database?
5.You recently changes the password of USER Ul and after sometime USER U1 come to you that he is not able to connect to DB what is the reason and what you will check to resolve?
6.Steps to configure physical standby?
7.what is command for adding datafiles on tablespace?
8.Can We resize redolog file?
9.Can we have two MRP process on DR server?
10.What is the procedure for RMAN BACKUP ? Have you done scripting?
11.What is snapshot too old error ? Why it is encounter?
12.How DB writer works?
13. what is checkpoint?

——————————–
#COMPANY-AMDOCS, Location -Pune
——————————–
1. Describe oracle architecture.
2. What is the role of PMON process?
3. What is Undo Tablespace? What is there in UNDO Tablespace?
4. What is Read Consistency?
5. What is UNDO Retention Period?
6. What the error related to UNDO Tablespace?
7. What is snapshot too old error ? Why it is encounter?
8. What is SGA & PGA?
9.Describe only memory architecture?
10. Is PGA is memory or process?
11.What is Flashback recovery? How we do that?
12.Have you worked on RAC, What are the services related to RAC?
13.Difference between traditional IMP/EXP vs Current IMPDP/EXPDP?
14.How you create a USER?
15.what do you mean by the statement select * from HR.TABLE? what is HR here?
16.You recently changes the password of USER Ul and aftersometime USER Ul come to you that he is not able to connect to DB what is the reason and what you will check to resolve?
17.Suppose we have table of 100GB and we have to export what parameter we are using so that export take less time to complete?
18.Is differential & Cummulative backup is same?
19. DR stands for?
20. what s the fullform of DBCA?
21. Difference between control file and parameter file?
22. Suppose one user want to create login but at the same time he wants once he login to server with provided password then ask for reset the password. What will be the query?

——————————-
#COMPANY-IQVIA, Location- Noida
——————————-
1. What DataBuffer Cache? How it is working?
2. What is Undo Tablespace?
3. What Cold Backup? Steps ?
4. What is RMAN? How to check the Default confriguration of RMAN?
5. Which services is responsible for Log shipping?
6. Which services is responsible for Log apply?
7. Have you done performance tunning?
8. Have you done Export / Import? steps?
9. Can We resize redolog file?
10. How will you verify that the standby is in syne with primary?
11. Whatis PITR ?Scenarion based question.
12. what sre the different modes of oracle dataguard?

———————————-
#COMPANY-CGI, Location- Bangalore
———————————-
1. What are my day to day DBA work?
2. What is RMAN? Have you done DB refresh through RMAN?
3. Reason for DB slowness?
4. What are the steps for deteing archivelogs?
5. What is the reson for generating lots of archives?
6. Expalin the scenarion for archive process comes in Picture?
7. What is oratab file?
8. What are the script that we are ecxecuting during binary installation? What is the use of that script?
9.Have you done silent installtion?
10.DB startup and shutdown stages?
11.Can we setup DR in two different version?
12.Password management question. What is password reuse time?

Facebook Comments Box

Comments

Leave a Reply

Your email address will not be published.