After applying a patch to the network device drivers in your operating system, you verify using CRS_STAT-T that everything runs normally. View Exhibitl for the CRS_STAT-T output.
After your coffee break, customers begin complaining about the performance of your Oracle Real Application Clusters database. Suddenly, the response time has increased and establishing new connections is slower than it used to be. You run CRS_STAT-T again to check if there is a problem.
Based on Exhibit2, what is your conclusion, and what would you do to correct this?

• A. There is no problem, so nothing needs to be corrected.
• B. You cannot tell what the problem is based on Exhibit2, so you cannot fix this.
• C. The second node in your cluster is down and, therefore, CRS has relocated the VIP from the second node to the first node. After you fix the problem on the second node, you have to relocate the relocated VIP back to its original node using the SRVCTL command.
• D. Somebody relocated the VIP from the second node to the first node for an unknown reason. You just have to relocate it back.
• E. The second node in your cluster is down and, therefore, CRS has relocated the VIP from the second node to the first node. After you fix the second node, CRS would relocate the relocated VIP back to its original node.

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 used in conjunction with parallel execution may provide for speedup of OLTP workload processes.
• C. RAC alone would increase availability when doing release upgrades.
• D. RAC would increase scalability for all application workloads in all cases.
• E. RAC would increase availability in the event of data failures.
• F. RAC used in conjunction with parallel execution may provide speedup of DSS queries.
• G. RAC would increase availability in the event of a network failure.
• H. RAC would increase availability in the event of node and instance failures.

On a UNIX platform, which three processes are required to be running on all nodes before initiating a cluster database creation? (Choose three.)

• A. racgmon.bin
• B. ocssd.bin
• C. evmd.bin
• D. crsd.bin

You have a four-node cluster with instances RDBD1, RDBD2, RDBD3, and RDBD4. While evaluating statspack reports, you find nq: TX- index contention on page one under the category op 5 Timed Events.
Further study finds an unusually high number of c buffer busy waits in the Wait Events section. Checking the Instance Activity Stats section, you see an unusually high value for eaf Node Splits. Using v$segment_statistics, you identify that the top segment with c buffer busy waits is the index prooducts_pk, which obtains the primary key from a sequence. You wish to present alternative solutions to the team to help reduce contention.
Which three actions would you recommend to reduce the overheads? (Choose three.

• A. Increase the sequence cache size if retaining the sequence.
• B. Set fast_start_mttr_target to a higher value.
• C. Re-create the index as a global hash partitioned index.
• D. Set _lm_msg_batch_size to a higher value.
• E. Re-create the table using a natural key instead of a surrogate key.
• F. Encourage shorter transactions.

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. only one on RAC01
• B. two on RAC01
• C. one on RAC01 and one on RAC02
• D. two on RAC02