What would you do to troubleshoot a RAC Network issue ?
Oracle Database Administrator Interview Questions
593 oracle database administrator interview questions shared by candidates
Basic computer knowledge and your passion to work in IT.
Nothing, Interviewer was not qualified enough. Started asking stupid questions and argued about few sure short answers. And Technical interviewer started asking about salary expectations !!!
1. Different between Index Full Scan and Index Fast Full Scan? 2. How do joins work in an SQL and how do they impact the execution plan? 3. What are ITLs and why do you use them? 4. How to handle heavy concurrent environment in oracle? What architecting solutions can you provide to achieve exceedingly good performance? 5. How many oracle wait events do you know and how to resolve each of them? 6. Most recent Oracle related admin/performance issues that you faced and how did you resolve them?
They asked me if i am OK working rotational shifts
Why you want to join oracle
Do you work on password reset & user creation. This is our expectation from 4 yrs experienced DBA.
About architecture
At the end of second round ,asked about feedback
basic to medium to advanced technical skills evaluated
Viewing 101 - 110 interview questions