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 products_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. Re-create the table using a natural key instead of a surrogate key.
• C. Encourage shorter transactions.
• D. Set _lm_msg_batch_size to a higher value.
• E. Re-create the index as a global hash partitioned index.
• F. Set fast_start_mttr_target to a higher value.

Your company has a combination of high availability and scalability requirements that need to be addressed, and RAC has been discussed as a solution. There are a mix of "off-the-shelf software products and homegrown applications currently in use in your environment that run on single-instance Oracle databases. You have been asked by the IT director to provide an impact analysis report to help assess the impact on applications when migrating to RAC. Which three are among the areas that should be examined for performance impact and application functionality impact or for both? (Choose three.)

• A. three-tier applications that use application global context variables
• B. applications that truncate tables in a data warehouse process
• C. applications that use large parallel full table scans
• D. client/server type applications that use application local context variables
• E. applications that use SQL profiles created by the ATO optimizer in the SQL Tuning Advisor
• F. applications that access small tables using the same index occasionally

You want check whether the group services node application is running on all the nodes in your cluster before you create a cluster database. Which utility can you use to make sure the node application is running on all nodes in the cluster?

• A. crs_stat
• B. addnode.sh
• C. onsctl
• D. crsctl
• E. Isnrctl

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. Somebody relocated the VIP from the second node to the first node for an unknown reason. You just have to relocate it back.
• B. 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.
• C. There is no problem, so nothing needs to be corrected.
• D. 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.
• E. You cannot tell what the problem is based on Exhibit2, so you cannot fix this.