Senior Oracle DBA Interview Questions and Answers for Experienced - 1
Question: 1
List the background processes required for RAC?
The background processes required for RAC are given as follows
ACMS – Atomic Controlfile to Memory Service
LMON – Global Enqueue Service Monitor
LMD – Global Enqueue Service Daemon
LMS – Global Cache Service Process
LCK0 – Instance Enqueue Process
RMSn – Oracle RAC Management Processes
RSMN – Remote Slave Monitor
Question: 2
How is RAC different from non RAC clusters?
A non RAC database has a single node while a RAC database has multiple (at least two) nodes.
The nodes in a RAC set up share storage.
RAC offers failover option while a non RAC database does not offer failover option because it is based on a single node.
Question: 3
What is interconnect network?
An interconnect network is a network between nodes of a cluster.
It uses switches to ensure that only nodes can access this network.
Generally, this is a high speed connection.
Question: 4
What is the benefit of using Virtual IP (VIP)?
Whenever an application uses VIP to connect to a database, it can failover to another available node in case of a failure of one node.
You need to use VIP as the host name in the Transparent Network Substrate (TNS) entry to use VIP.
Question: 5
How does RAC ensures data consistency between two nodes?
RAC ensures data consistency between two nodes through cache function.
- Oracle DBA RAC Interview Questions and Answers
- Oracle RAC Interview Questions and Answers for Experienced
- Oracle Database 11g Architecture Interview Questions and Answers Pdf
- Oracle DBA Scenario Based Interview Questions and Answers
- Senior Oracle DBA Interview Questions and Answers for Experienced
- Oracle Developer Interview Questions and Answers for Experienced
Gross Domestic Product and Its Growth Class 10 Questions Pdf More
Industrial Cluster in Tamil Nadu TNPSC Questions Pdf More
Food and Security TNPSC Questions Pdf More
Economics Food Security and Nutrition Class 10 Questions Pdf More
Class 10th Social Indian Constitution Pdf More
Top 50+ Java Garbage Collections Interview Questions and Answers More
Indus Valley Civilization Online Test More
1000+ Environmental Science and Engineering MCQ Questions & Answers More
1000+ SBI PO Prelims Questions and Answers Pdf More
Online General Knowledge Quiz with Answers More