1. What is clustering factor ?
2. What is bind picking ?
3. What is histogram ?
4. What is dynamic sampling ?
5. What exactly statistics collect ?
6. What is latch and mutex ?
7. Difference between btree index and bitmap index ?
8. What is the diff between 10046 and 10053 trace ?
9. What are the diff trace level ?
10. Tell me 5 to 10 12c new features ?
11. What are the pre-checks before patching ?
12. What is rolling patch ?
13. What is static registration ?
14. How user will access a 10GB table where your SGA size is 2GB ?
15. What is the difference between VIP and Scan ip ?
16. What is GNS and how it defers from DNS ? and How will you configure it ?
17. What is slit brain syndrome ?
18. What is the use of VIP?
19. What are different areas you look in AWR report when a performance issue occurs ?
20. A Session using more memory . does it will be reported in AWR report ?
21. Default location for OCR backup ?
22. How to identify master node ?
23. Tell me 5 back ground processes in RAC ?
24. Who do you troubleshoot if any of RAC daemon was down ?
25. What is shmmax in linux ?
26. Difference between index rebuild and rebuild online ?
27. Difference between 10g and 11g SGA setting ?
28. What is GRD, GCS ?
29. What is cursor table ?
30. How to find how many oracle homes installed in linux system or where is your orainventory location where you are login first time ?
31. How oracle recover database when oracle instance crashes ?
32. What is the last performace issue you resolved recently ?
33. How to recover a lost table in prod ?
34. What is dynamic remastering ? When will the dynamic remastering happens?
35. What are the major RAC wait events?
36. Why should we you EXADATA machine instead on standard machine having equal set up ?
37. What is difference betweeen PHYSICAL, LOGICAL and SNAPSHOT standby ? 38. What is materialized view and how it differs from normal view ?