Oracle DBA Scenario Based Interview Questions and Answers - 1

Question: 1

Name the three network component of RAC?

The three network components of RAC are public, private and VIP.

Question: 2

What is the use of Oracle Cluster Registry (OCR)?

OCR stands information about cluster resources and their configuration.

The CRS process uses that information to manage resources.

Question: 3

What are the major RAC wait events?

The major RAC wait events are associated with buffer cache.

The most common wait events in RAC are gc cr request, which occurs when an instance tries to retrieve the data from the remote cache and gc buffer busy, which occurs when one instance finds the GC buffer busy.

Question: 4

What is Global Resource Directory (GRD)?

GRD is used to GES and GCS to maintain status of datafiles and cached blocks.

This process provides required information for cache fusion and maintains data integrity.

Question: 5

List the characteristics of oracle services?

An Oracle service must have a unique name. It offers workload balancing and failover options.