Oracle Rac Interview Questions

Oracle Rac Interview Questions

1. How end-user can connect to the RAC Database?
2. What is a Voting Disk and why we keep an odd number of VD?
3. What is a split-brain syndrome in RAC? If this issue is there for a longer time, then what happens??
4. Explain high-level steps to install Oracle 3 node RAC database?
5. Explain patching types in oracle RAC and steps to apply a patch?
6. Can we use a different Operating system when configuring RAC?
7. Clusterware fencing is available from which version?
8. What are the two methods of Clusterware communication?
9. How many nodes we can configure in RAC?
10. Can you use IPv6 for Private IP?
11. Differences between Single Instance Vs RAC?
12. What files store in the Clusterware?
13. What is the File system that certified for RAC?
14. What protocol used in the oracle RAC interconnect network?
15. What do you need to plan before migrating Single Instance to RAC?
16. How many nodes we can configure in RAC?
17. Can we use a different Operating system when configuring RAC?
18. Clusterware fencing is available from which version?
19. What is two methods for Clusterware communication?
20. How Many IP needed for 2 node RAC according to Oracle best practices?
21. What is Cache Fusion?
22. What is GRD?
23. What is the role of the Voting Disk?
24. How to check resources in the cluster?
25. How to check clusters are up ON all nodes?
26. How to check the cluster is UP on a particular node?
27. How to bring Down the one specific node in RAC?
28. What will you check if the query is running slow?
29. DIfference between Bitmap & B-tree Index?
30. Tell me Wait Event in RAC?
31. How many disks in ASM Normal Redundancy?
32. How to create Data Guard?
33. How to fix the gap in Data Guard?
34. Difference between DBFile Sequential and Scattered Reads?
35. What is Fragmentation in Oracle Database?
36. Table Fragmentation in Oracle Database?
37. How to recover Table in oracle database?
38. Can we transfer the data between Linux to windows?
39. Difference between b-tree and bitmap index?
40. What is gc cr request in RAC?
41. What is the Library cache lock? When it will occur?
42. How you solve Library cache lock issues?
43. Library cache Lock issues In AWR which section you will look in to?
44. In Library cache lock how connection management call elapsed time will impact?
45. One user fire select statement for the long table after that one user drop that table. then what will happen for a select query?
46. Rolling Upgrade in Oracle RAC?
47. How to Fix the log switches problem?
48. Oracle Database “19c New Features”?
49. How to check ASM status?
50. Have you done ASM metadata backup?
51. What is SQL BaseLine?
52. What are the two source attributes for SQL Base Line?
53. How to Create a SQL Base Line?
54. In one Table Index is there but Optimizer is not using index what will be the reason?
55. What are Deadlocks? How it will be resolved?
56. One user A Started a Transaction after that user B started the transaction on the same row in that table. So Deadlock occurs. Which user Transaction will rollback? DBA will rollback or it happens automatically?
57. What are the Locks? Tell me the name Object Type of Lock?
58. If user Fire Select query Statement so Lock will happen or not?
59. When the user fires the Select statement than in backend how it will execute?
60. What is the SQL patch? Why did we use it?
61.