How to generate oracle awr report when you don't access to EM ?
Database Manager Interview Questions
5,609 database manager interview questions shared by candidates
Introduce yourself in 1 to 1 interview
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?
When was a time you made a mistake, and how you did you handle it afterward?
They asked me if i am OK working rotational shifts
Why you want to join oracle
Its your log out time and you are in between of an issue, what will you do??
Willing to relocate
What are the ACID properties of an Oracle transaction?
Describe how you have used various procedures belonging to DBMS_SQL package.
Viewing 901 - 910 interview questions