I applied online. The process took 2 weeks. I interviewed at Oracle (Kairo, ) in Apr 2018
Interview
take 2 weeks, and it was very easy 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?