Oracle Developer Interview Questions and Answers for Experienced - 1

Question: 1

What are the different types of connection load balancing?

Following are the two types of connection load balancing

Server side load balancing

Client side load balancing

Question: 2

Explain the Fast Application Notification (FAN) feature of RAC?

FAN is an application programming interface (API) based on Oracle Notification Services (ONS). This API enables the application to receive notification whenever a FAN event happens.

After application code is enabled to receive FAN event notifications, it can respond to the events appropriately.

Question: 3

Can rolling upgrading be used to upgrade from Oracle 10g to Oracle 11g database?

No, it can only be used for Oracle database 11g releases.

Question: 4

What is the use of LMS?

LMS stands for Lock Monitor Service.

The primary job of the process is to transfer data blocks between cache of different nodes using high speed interconnect.

It is the most important and critical process for cache fusion. Each node has at least two LMS processes.

Question: 5

What is VIP?

VIP is an address, which is not directly connected to any host. It is a spare address, which can be mapped to another host in the same subnet.

It can be easily mapped to another host in case of a failure.