What would you do to troubleshoot a RAC Network issue ?
Oracle Database Administrator Interview Questions
594 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
basic to medium to advanced technical skills evaluated
Do you work on password reset & user creation. This is our expectation from 4 yrs experienced DBA.
About architecture
oracle installation using DBCA
Viewing 101 - 110 interview questions