Which two statements are true about Instance recovery in a RAC environment? A. Parallel instance recovery will work even If the RECOVERY_PARALLELISM initialization parameter is set to 0 or 1. B. Increasing the size of the default buffer cache can…
Your production environment cluster is running Oracle Enterprise Linux and currently has four nodes. You are asked to plan for extending the cluster to six nodes. Which three methods are available to add the new nodes? A. silent cloning usingcrsctlclone…
Which three statements define a cluster? A. is a group of independent, but interconnected computers that act as a single system B. can be deployed to increase availability and performance C. can be deployed to balance a dynamically changing workload…
Which three statements are true about the logging or tracing of Java-based Oracle tools? A. By default, Oracle logs actions for DBCA and DBUA. B. For tools such as SRVCTL and CLUVFY, tracing can be enabled by setting srvm_trace =…
Which two statements are true regarding the Active Session History (ASH) reports for RAC? A. They provide details about Oracle databases for all current sessions, and history of past session all RAC nodes. B. They provide statistics about Oracle databases…
You notice that there is a very high percentage of wait time for RAC database that has frequent insert operations. Which two recommendations may reduce this problem? A. shorter transactions B. increasing sequence cache sizes C. using reverse key indexes…
Which are the key factors that you should consider before converting a single-instance database to an Oracle Real Application Cluster (RAC) database to guarantee a successful media recovery? A. If the database is in archive log mode, the archive file…
Your two-instance RAC database is running in ARCHIVELOG mode. The instance running on node1 fails and this failure is detected by the instance running on node2, which initiates the recovery process for node1. Which process will read the redo log…
Assume that you want to make a connection to the ERP service associated with a newly created RAC database called PROD on a cluster called cluster01 that consists of three nodes: node1, node2, and node3. Which two connect strings are…
Examine the Exhibit. Which two statements are true regarding the Average Active Sessions chart on the performance page? A. It shows active aggregate wait class statistics across all the instances in the cluster database. B. It shows active aggregate wait…