Top 100+ Oracle Real Application Clusters Interview Questions And Answers
Question 1. List The Background Processes Required For Rac?
The background techniques 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. What Is A Crs Resource?
Oracle Clusterware is used to manipulate excessive-availability operations in a cluster. Anything that Oracle Clusterware manages is called a CRS useful resource. Some examples of CRS assets are database, an example, a provider, a listener, a VIP cope with, an software procedure and so on.
PL/SQL Interview Questions
Question three. What Kind Of Storage We Can Use For The Rac Database Storage?
OCFS (Release 1 or 2)
1/3 party cluster document gadget together with GPFS or Veritas
Question 4. What Is Oclumon Used For In A Cluster Environment?
The Cluster Health Monitor (CHM) stores running system metrics inside the CHM repository for all nodes in a RAC cluster. It shops facts on CPU, memory, method, community and other OS data, This information can later be retrieved and used to troubleshoot and discover any cluster associated issues. It is a default component of the 11gr2 grid set up. The facts is saved within the master repository and replicated to a standby repository on a different node.
Oracle DBA Tutorial
Question 5. What Are The File Systems And Volume Management Techniques Used In Oracle Rac?
The file gadget and quantity management in Oracle RAC should recognize approximately the structure this is getting used and it should be aware of the clusters that are involved in it.
Oracle supports automatic garage control that automates the storing of files and setup the communication in between the databases storage pools.
Oracle supports the high overall performance of the enter and output of the storage subsystem by means of offering easy gear to use to maximize it.
They provide a way to balance the burden across the to be had assets that allows an appropriate optimization of the file machine and extent control.
Oracle RAC offers dynamic extent supervisor and it has a document system that incorporates the facts of the cluster document device as properly.
The cluster report gadget in oracle is known as as (OCFS) and it has the connection with the databases that offer uncooked gadgets and command line features.
Oracle DBA Interview Questions
Question 6. What Is A Vip In Rac Use For?
The VIP is an alternate Virtual IP address assigned to each node in a cluster. During a node failure the VIP of the failed node moves to the surviving node and relays to the utility that the node has long past down. Without VIP, the software will look ahead to TCP timeout after which find out that the session is not live because of the failure.
Question 7. What Is The Use Of Atomic Control File Memory Service (acms)?
ACMS guarantees global updates to System Global Area (SGA) in a RAC installation.
DB2 Using SQL Tutorial DB2 Using SQL Interview Questions
Question 8. Mention How Oracle Flex Asm Works?
Oracle Flex ASM example while fails on a specific node, then the Oracle Flex ASM instance is passed over to another node inside the cluster.
Question nine. What Are The Provisions And Resources Provided In The Oracle’s Cloud Server?
Oracle’s cloud server affords scalability by means of including extra servers to a pool while there's a requirement of any processing electricity or area.
Provision to pay in keeping with hour/use as in step with the requirement, to, maintain the general value low and construct the functionality on the high-quit systems.
Oracle RAC presents the platform’s structure as it offers low-fee hardware platform to supply high nice provider and provide greater scalability and availability.
This reduces the administration fee and presents precise management techniques and tools to monitor the offerings.
This lets in the customers to build their own infrastructure on the idea of cloud.
RMAN (Recovery Manager) Interview Questions
Question 10. Explain The Hardware Architecture Used In Oracle Rac?
The Hardware Architecture of the Oracle RAC clusters presents a shared structure with the server swimming pools and lets in all the garage gadgets to be shared.
Hardware Architecture supports different types of storage networks like Network connected garage (NAS), Storage Area Network (SAN) and SCSI disks.
Hardware structure is such that it presents appropriate selections for the garage pools and device that offers scalability and flexibility to the general machine.
The structure ought to incorporate the input and output for the utility that need to be evolved after which the gadget can have extra scalability.
Hardware architecture supports greater software to be introduced inside the server pool and permits better integration of services.
Question eleven. Where Are The Database Software Files Stored On A Rac Environment?
The base software is hooked up on each node of the cluster and the database garage on the shared disks.
Oracle MySQL five.6 Database Administrator Interview Questions
Question 12. What Is Rolling Upgrade?
Rolling upgrade refers back to the software program upgrading at the same time as database continues to be useful without bringing the database down for improve.
This is the new feature of Oracle 11g.
PL/SQL Interview Questions
Question thirteen. What Are The Types Of Connection Load-balancing?
There are two varieties of connection load-balancing: server-aspect load balancing and client-aspect load balancing.
Question 14. What Is Required By Oracle Rac Database To Connect To A Network?
Oracle RAC calls for an energetic connection of the network to the LAN (Local Area Network) in order that the database server may be discovered and related.
The database server is further having connections with utility servers that shop the applications and permit consumer to switch their records.
The connection is required with the server pool so that the switch of services and packages may be carried out on call for basis.
The interconnection among the networks is in reality vital because it has to maintain the general drift of the pools and the sources.
Oracle RAC offers aid to redundant interconnects quite and it gives an typical infrastructure answer.
The load balancing and inter-node messaging can be dealt with more carefully whilst the networks or the servers are interconnected to every other.
Question 15. What Is Acfs?
ACFS gives an Oracle Home shared report machine or a preferred purpose clustered report machine on ASM storage.
It desires ASM Dynamic Volume Manager (ADVM) to talk to the running machine.
Oracle Exadata Database Interview Questions
Question sixteen. Where Are The Cluster Ware Files Stored On A Rac Environment?
The Clusterware is hooked up on every node (on an Oracle Home) and on the shared disks (the voting disks and the CSR record).
Question 17. What Is Global Services Daemon (gsd)?
GSD runs on each node and isn't always an Oracle history procedure.
This procedure performs administrative duties, which includes startup and shutdown, based on the requests from distinctive customers, which include DBCA and organization manager.
Oracle GoldenGate Interview Questions
Question 18. What Is Cache Fusion?
In a RAC environment, it's miles the combining of records blocks, which can be shipped across the interconnect from far off database caches (SGA) to the local node, with the intention to satisfy the necessities for a transaction (DML, Query of Data Dictionary).
Oracle DBA Interview Questions
Question 19. What Is The Main Purpose Of Oracle Real Application Clusters (rac)?
Oracle Real Application (RAC) affords the interaction of executable document with the Oracle database.
It lets in the walking of any packaged or custom constructed application with the Oracle database this is running on a server pool.
It provides very high level of availability, flexibility and scalability to run the application and store it to the database.
It creates the database such that if the pool fails then the database is continued to run from the remaining servers and the load can be dispensed.
It makes it less complicated for the administrator to hold many servers at the same time via load-balancing strategies and presenting provision to add more and more servers whilst the burden will increase.
Question 20. What Is Rac Cluster?
RAC cluster is a database with a shared cache architecture that overcomes the restrictions of conventional shared not anything and shared disk approaches.
It is a key element of Oracle's private cloud architecture.
Oracle DBA Troubleshooting Interview Questions