RAC (Real Application Clusters) Interview Preparation Guide Download PDF
Real Application Clusters (RAC) frequently Asked Questions by expert members with experience in RAC (Real Application Clusters). These questions and answers will help you strengthen your technical skills, prepare for the new job test and quickly revise the concepts
20 Real Application Clusters (RAC) Questions and Answers:
1 :: Can you explain how is clustered database important in Oracle RAC architecture?
- Clustered database is just like a single database accessed by multiple instances that are running on the server.
- The instances are being run separately or individually on the server pool and when the demands rise they are shifted to acquire more space according to the requirements.
- Clustered database provides dynamic access to the database and on the demand of additional resources they are added to the server pool.
- If one cluster is taking up the load then that load is shared between other clusters running on the server and the application services are provided in a much faster and better way.
- This also allows the adding of additional resources dynamically to the server pool with no downtime and the application starts running soon it is deployed on the server.
- The instances are being run separately or individually on the server pool and when the demands rise they are shifted to acquire more space according to the requirements.
- Clustered database provides dynamic access to the database and on the demand of additional resources they are added to the server pool.
- If one cluster is taking up the load then that load is shared between other clusters running on the server and the application services are provided in a much faster and better way.
- This also allows the adding of additional resources dynamically to the server pool with no downtime and the application starts running soon it is deployed on the server.
2 :: Can you explain what are the provisions and resources provided in the Oracle’s cloud server?
- Oracle’s cloud server provides scalability by adding more servers to a pool when there is a requirement of any processing power or space.
- Provision to pay per hour/use as per the requirement, to, keep the overall cost low and build the functionality on the high-end systems.
- Oracle RAC provides the platform’s architecture as it provides low-cost hardware platform to deliver high quality service and provide more scalability and availability.
- This reduces the administration cost and provides good management techniques and tools to monitor the services.
- This allows the users to build their own infrastructure on the basis of cloud.
- Provision to pay per hour/use as per the requirement, to, keep the overall cost low and build the functionality on the high-end systems.
- Oracle RAC provides the platform’s architecture as it provides low-cost hardware platform to deliver high quality service and provide more scalability and availability.
- This reduces the administration cost and provides good management techniques and tools to monitor the services.
- This allows the users to build their own infrastructure on the basis of cloud.
3 :: Tell me what is the function of Cache fusion in Oracle RAC?
- Cache function is used to show the storage of the information in the clustered network with the Oracle database.
- This uses the database transfer medium and it involves two nodes where one reads the data block from the disk and another write the data to the same disk.
- It provides very good performance and increases the flexibility in terms of execution of the application that is using the platform.
- RAC uses a dedicated server for its network connection and the cache fusion is an internal part to the cluster.
- It uses the same database and keeps the things in the cache till the information is not needed anymore by any other application. It queries the data only when it totally necessary to do it.
- The query from the user always results in the most current version even after the data is being modified.
- This uses the database transfer medium and it involves two nodes where one reads the data block from the disk and another write the data to the same disk.
- It provides very good performance and increases the flexibility in terms of execution of the application that is using the platform.
- RAC uses a dedicated server for its network connection and the cache fusion is an internal part to the cluster.
- It uses the same database and keeps the things in the cache till the information is not needed anymore by any other application. It queries the data only when it totally necessary to do it.
- The query from the user always results in the most current version even after the data is being modified.
4 :: Please explain what is required by Oracle RAC database to connect to a network?
- Oracle RAC requires an active connection of the network to the LAN (Local Area Network) so that the database server can be found and connected.
- The database server is further having connections with application servers that store the applications and allow user to transfer their data.
- The connection is required with the server pool so that the transfer of services and applications can be done on demand basis.
- The interconnection between the networks is really important as it has to maintain the overall flow of the pools and the resources.
- Oracle RAC provides support to redundant interconnects relatively and it provides an overall infrastructure solution.
- The load balancing and inter-node messaging can be handled more carefully when the networks or the servers are interconnected to each other.
- The database server is further having connections with application servers that store the applications and allow user to transfer their data.
- The connection is required with the server pool so that the transfer of services and applications can be done on demand basis.
- The interconnection between the networks is really important as it has to maintain the overall flow of the pools and the resources.
- Oracle RAC provides support to redundant interconnects relatively and it provides an overall infrastructure solution.
- The load balancing and inter-node messaging can be handled more carefully when the networks or the servers are interconnected to each other.
5 :: Can you explain what are the key components of Oracle’s Maximum Availability Architecture?
- Oracle Real Application Clusters are the key components of the existing architecture.
- It provides directions and management of the applications that needs to be architect using the architecture.
- It provides high scalability of the applications that is being run on a single server and it takes the advantage of lower cost commodity hardware to reduce the cost.
- It enables the Oracle database to be run and maintained using the business application that are on the server pools and involves packaged products as well.
- It provides a way to integrate the in-house applications that are developed using the oracle database and its technology.
- It allows easy management of the server by providing the ability to remove the server as a single point of failure in the database application environment.
- It provides directions and management of the applications that needs to be architect using the architecture.
- It provides high scalability of the applications that is being run on a single server and it takes the advantage of lower cost commodity hardware to reduce the cost.
- It enables the Oracle database to be run and maintained using the business application that are on the server pools and involves packaged products as well.
- It provides a way to integrate the in-house applications that are developed using the oracle database and its technology.
- It allows easy management of the server by providing the ability to remove the server as a single point of failure in the database application environment.
6 :: Do you know what is the main purpose of Oracle Real Application Clusters (RAC)?
- Oracle Real Application (RAC) provides the interaction of executable file with the Oracle database.
- It allows the running of any packaged or custom built application with the Oracle database that 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 distributed.
- It makes it easier for the administrator to maintain many servers at the same time by load-balancing techniques and providing provision to add more and more servers when the load increases.
- It allows the running of any packaged or custom built application with the Oracle database that 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 distributed.
- It makes it easier for the administrator to maintain many servers at the same time by load-balancing techniques and providing provision to add more and more servers when the load increases.
7 :: Do you know the Oracle Real Application Clusters Architecture?
- Oracle RAC consists of a database that is represented in a clustered manner in the architecture.
- The cluster is the collection or pool of independent servers that make up one single system.
- Cluster architecture provides more flexibility to manage and follow a modular incremental approach to improve the fault errors and provide an incremental system.
- This architecture provides the maximum security in terms of ensuring high availability of the resources to the users.
- It provides the resources on demand and provides hardware architecture such that a single point of failure is being removed.
- The architecture provides the decoupling of the Oracle instance like the process and memory that are running on the server from the Oracle database.
- The cluster is the collection or pool of independent servers that make up one single system.
- Cluster architecture provides more flexibility to manage and follow a modular incremental approach to improve the fault errors and provide an incremental system.
- This architecture provides the maximum security in terms of ensuring high availability of the resources to the users.
- It provides the resources on demand and provides hardware architecture such that a single point of failure is being removed.
- The architecture provides the decoupling of the Oracle instance like the process and memory that are running on the server from the Oracle database.
8 :: Do you know what is the functionality and features provided by Oracle Clusterware?
- Oracle Clusterware is a portable solution that comes up with the Oracle database to be used by the application that is being integrated and designed.
- It provides a complete solution of all the clustering problems and supports all the applications that use the functionality of Oracle database.
- It helps in implementation of Oracle RAC and support the clustered database as well that allow more and more applications to run.
- It manages all the Oracle RAC database integrations on the server and system with their statuses and provides an automatic recovery in case of any failure occurs.
- It provides high availability APIs that can be used with the applications and manage to provide a framework that can be integrated and used to develop more applications.
- It allows the user to use the registration services that allow starting, stopping and monitoring of the processes if any failure occurs.
- It provides a complete solution of all the clustering problems and supports all the applications that use the functionality of Oracle database.
- It helps in implementation of Oracle RAC and support the clustered database as well that allow more and more applications to run.
- It manages all the Oracle RAC database integrations on the server and system with their statuses and provides an automatic recovery in case of any failure occurs.
- It provides high availability APIs that can be used with the applications and manage to provide a framework that can be integrated and used to develop more applications.
- It allows the user to use the registration services that allow starting, stopping and monitoring of the processes if any failure occurs.
9 :: Can you please explain the Hardware Architecture used in Oracle RAC?
- The Hardware Architecture of the Oracle RAC clusters provides a shared architecture with the server pools and allows all the storage devices to be shared.
- Hardware Architecture supports different types of storage networks like Network attached storage (NAS), Storage Area Network (SAN) and SCSI disks.
- Hardware architecture is such that it provides appropriate choices for the storage pools and system that provides scalability and flexibility to the overall system.
- The architecture should contain the input and output for the application that need to be developed and then the system can have more scalability.
- Hardware architecture supports more application to be added in the server pool and allows better integration of services.
- Hardware Architecture supports different types of storage networks like Network attached storage (NAS), Storage Area Network (SAN) and SCSI disks.
- Hardware architecture is such that it provides appropriate choices for the storage pools and system that provides scalability and flexibility to the overall system.
- The architecture should contain the input and output for the application that need to be developed and then the system can have more scalability.
- Hardware architecture supports more application to be added in the server pool and allows better integration of services.
10 :: Tell me what are the conditions kept in mind while connecting the Oracle RAC with the network?
- Oracle uses the UDP over the GigE to interconnect to the cluster and the servers. It makes use of crossover cables to interconnect the database.
- It supports more than one servers connected through LAN connection and shared a pool of storage.
- Oracle Clusterware supports the more than one node in the cluster and it supports the node to be running more than one different operating systems.
- All the servers should support the same architecture and have the same detail information as well. This way the servers need to be in synchronization with each other.
- The servers need to run on a particular node and communicate with other servers that are running on several other nodes.
- It supports more than one servers connected through LAN connection and shared a pool of storage.
- Oracle Clusterware supports the more than one node in the cluster and it supports the node to be running more than one different operating systems.
- All the servers should support the same architecture and have the same detail information as well. This way the servers need to be in synchronization with each other.
- The servers need to run on a particular node and communicate with other servers that are running on several other nodes.