Oracle Database 11g Architecture Interview Questions and Answers Pdf - 1

Question: 1

List the components of Oracle Clusterware?

The components of Oracle Clusterware are given as follows:

Oracle Process Monitor Daemon

RACH Process

Oracle Notification Service

Event Manager

Cluster Ready Service (CRS)

Cluster Synchronization Services (CSS)

Question: 2

What is RAC?

Real Application Cluster (RAC) is a clustering solution. It ensures high availability for database applications.

A RAC setup contains at least two nodes for a database.

RAC provides high availability and load balancing through these nodes.

Question: 3

What is the advantage of using ASM?

Two main advantages of using ASM are performance benefits and manageability.

I/O operations in ASM are managed directly by Oracle Kernel bypassing operating system layer; therefore, it provides better performance for I/O operations.

ASM storage is referred to as disk group, which is a set of multiple disks. The system does not have to deal with individual disks; therefore, it is easier to manager ASM storage.

Question: 4

What enables the load balancing of applications in RAC?

Oracle Net Services enables the load balancing of applications in RAC.

Question: 5

What is the Cluster Ready Service (CRS) resource?

CRS is the main program that manages high availability operations.

The resource managed by CRS process is called CRS or cluster resource, such as dataabase, instance, service, listener, VIP address, or application process.