referential integrity , joins, ddl dml
Oracle Database Interview Questions
505 oracle database interview questions shared by candidates
why you preferred our company?
He started out by saying this would be a conversation, not an interview. We spent about 40 minutes talking at a general level about bank, the job and him. Spent about 10 minutes discussing my background. We touched on the importance of prayer to him, and two other team leads that report to him and their roles ant outlook.
previous company role Processes errors regular issues faced
What would you do to troubleshoot a RAC Network issue ?
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
Viewing 91 - 100 interview questions
See Interview Questions for Similar Jobs
Oracle Database DeveloperSql DeveloperPlsql DeveloperHadoop Developer Or Hadoop AdministratorSenior Database DeveloperSenior Oracle Database AdministratorSql Database EngineerJunior Oracle Database AdministratorSql Server Database DeveloperSenior Database EngineerSql Database DeveloperDatabase Del Server SqlIt Technical AnalystOracle Plsql DeveloperOracle Pl Sql DeveloperSenior Pl Sql DeveloperPower Bi Support EngineerHadoop Administrator