Which three statements about Snapshot Control File Management in a RAC environment are true? (Choose three.)

• A. RMAN parameters controlling snapshot control files can be configured from the Enterprise Manager Cluster Database home page.
• B. You can use a cluster file system or a raw device to store snapshot control files.
• C. By default, the snapshot control file is created on the node that is making the backup.
• D. You need to configure a default path and file name for these snapshot control files that is valid on every node from which you might initiate an RMAN backup.

You define the ERP service using this statement:
srvctl add service -d RACDB -s ERP -r RAC01 -a RAC02 -P PRECONNECT srvctl start service -d
RACDB -s ERP
You then use this connect string to connect to your RAC instances:
ERP =
(DESCRIPTION =(FAILOVER=ON)(LOAD_BALANCE=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=N1 VIP)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=N2VIP)(PORT=1521))
(CONNECT_DATA = (SERVICE_NAME = ERP)
(FAILOVER_MODE =
(BACKUP=ERP_PRECONNECT)(TYPE=SESSION)(METHOD=PRECONNECT))))
You successfully establish a connection to your RAC database using the above connect string.
How many connections are established, and on which instances?

• A. two on RAC02
• B. two on RAC01
• C. one on RAC01 and one on RAC02
• D. only one on RAC01

Your network administrator wants to know why you need extra IP addresses for your Oracle Real Applications Cluster now that you are upgrading from OracleSi to Oracle 10g. Which four statements would you use to explain to your network administrator the reason for requiring extra IP addresses? (Choose four.)

• A. The VIPs are used to circumvent network timeouts on the Cluster Interconnect.
• B. Database clients should connect to a RAC database using VIPs for the best High Availability solution.
• C. The VIPs are used to prevent connection request timeouts during client connection attempts.
• D. A VIP would notify its client when a failure occurs.
• E. The VIPs should be registered in the DNS.
• F. The VIPs should not be registered in the DNS.
• G. The VIP addresses must be on the same subnet as the public host network addresses.
• H. A VIP would always accept a connection from a client.

You have attended a user group presentation on RAC and based on what you have learned you feel that your company would benefit from having the RAC option to meet its Oracle database requirements in several ways. Your manager does not know much about RAC and asks you to create a presentation to the team explaining RAC, and whether it should be implemented in your installation. Which three statements explain the benefits and implications of RAC? (Choose three.)

• A. RAC alone would not help protect from human errors.
• B. RAC would increase availability in the event of node and instance failures.
• C. RAC would increase scalability for all application workloads in all cases.
• D. RAC would increase availability in the event of data failures.
• E. RAC used in conjunction with parallel execution may provide for speedup of OLTP workload processes.
• F. RAC used in conjunction with parallel execution may provide speedup of DSS queries.
• G. RAC alone would increase availability when doing release upgrades.
• H. RAC would increase availability in the event of a network failure.

View the Exhibit, which displays the cluster database performance page after the same workload has been executed three times on your cluster without varying any non-Oracle workloads on the cluster. What are the two ways by which you can tell that the corresponding application was better tuned during the second and third execution? (Choose two.)

• A. The database throughput graphic is below the red dashed line during the last execution.
• B. There is less paging each time.
• C. The run queue length is going down each time.
• D. It takes less time to execute the workload each time.
• E. The number of transactions per second is getting higher each time.