Oracle DBA Interview Questions
A. COMPANY- Oracle (OFSS), Location -Bangalore
1. Describe oracle architecture.
2. What is the role of PMON process?
3. What are the stages of Database startup process?
4. What is the backup process in your current organization?
5. How do you restore DB from available 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 dictionary 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 Installation? what kernel parameter you are setting before Installation? Name Please.
14.What are stwps for configuring Oracle Data guard/ physical standby?
15.How you will check directory size in ASM?
B. 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 definition.
5.What is cause of DB slowness? At least 5 points.
C. 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 data files on table space?
8.Can We resize redo log 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?
D. COMPANY-AMDOCS, Location -Pune
1. Describe oracle architecture.
2. What is the role of PMON process?
3. What is Undo Table space? What is there in UNDO Table space?
4. What is Read Consistency?
5. What is UNDO Retention Period?
6. What the error related to UNDO Table space?
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 after sometime 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 & Cumulative backup is same?
19. DR stands for?
20. what s the full form 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?
E. COMPANY-IQVIA, Location- Noida
1. What Data Buffer Cache? How it is working?
2. What is Undo Table space?
3. What Cold Backup? Steps ?
4. What is RMAN? How to check the Default configuration of RMAN?
5. Which services is responsible for Log shipping?
6. Which services is responsible for Log apply?
7. Have you done performance tuning?
8. Have you done Export / Import? steps?
9. Can We resize redo log file?
10. How will you verify that the standby is in syne with primary?
11. What is PITR ? Scenario based question.
12. what are the different modes of oracle data guard?
F. 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 deleting archive logs?
5. What is the reason for generating lots of archives?
6. Explain the scenario for archive process comes in Picture?
7. What is oratab file?
8. What are the script that we are executing during binary installation? What is the use of that script?
9.Have you done silent installation?
10.DB startup and shutdown stages?
11.Can we setup DR in two different version?
12.Password management question. What is password reuse time?
