ORACLE REALTIME INTERVIEW QUESTIONS -1

  ORACLE REALTIME INTERVIEW QUESTIONS 

1. Explain how RAC cluster starts.

    Hint :  (like HAS,CRS,NODEAPPS,ASM,DATABASE,SERVICES)

2. Explain the processes that involved in starting a RAC cluster.

3. What is cache fusion

4. what is difference between olr and ocr

5. What is gpnp profile

6. Where will be RAC logs stored

7. How ips are needed to configure 19c rac.

8. What is VIP? Why it is used.

9. what is different between srvctl and crsctl commands

10. How will you tune a sql?

11. How to find long running sql for a given time.

12. How to check current long running sql?

13. Difference between lock and deadlock

14. Difference between SPM and SQL PRofile.

15. Why we should use SQL profile. How to create a sql profile.

16. Is it possible take expdb from standby database?

17. How will you apply opatch on grid and database? What precheck you will do?

18. What will ./datapatch verbose do? What you will check on dba_registry_sqlpatch?

19. How to restore a given rman backup into QA?

20. How to port sql profile one DB to another DB?

21. What will you see in AWR?

22.  Do you have experience on Data encryption?

23. How will you sync standby database if archive logs are lost?

24. If there is frequent interconnect disconnection, what will happen

25. How to do a database upgrade with minimal downtime?

26. What is the use of scan-ips

27.  Steps to change maximum availability to maximum performance.