what is the default path of the initialization parameter file from an Oracle instance
Database Designer Interview Questions
5,609 database designer interview questions shared by candidates
Leetcode style queries, but written on paper(?)
How to generate oracle awr report when you don't access to EM ?
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
1. select second largest salary from the table
Its your log out time and you are in between of an issue, what will you do??
Viewing 901 - 910 interview questions