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

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

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

Richard is a senior DBA and has prepared a plan for RAC implementation in his company. Given below are some of the tasks that he would perform as part of the plan: 1) Creating the Raw Devices Mapping file 2) Creating database services 3) Binding the partitions to raw devices 4) Creating the Voting Disk file 5) Creating an initialization parameter file 6) Creating the Oracle Cluster Registry (OCR) file 7) Creating the tnsnames.ora file 8) Creating the database control file
During the creation of the RAC database, Richard can use the Database Configuration Assistant (DBCA) to perform some of these steps but not all of them. Which steps should be completed before Richard starts creating the database by using DBCA?

• A. 2, 5,6,7,8
• B. 1, 3,4,6
• C. 1, 2,4,5,6,7
• D. 3, 4,6,7,8
• E. 2, 5,7,8

Your company is about to switch from one Internet Service Provider (ISP) to another, and this change of ISP comes along with a whole new set of network addresses. Your job is to change the VIP addresses of your company's Oracle Cluster.
How would you apply this change?

• A. Reinstall the Oracle Clusterware layer of your cluster.
• B. Change the VIP addresses on the cluster using SRVCTL while the cluster is fully functional.
• C. Change the VIP addresses in DNS and the cluster would pick up the new addresses automatically.
• D. Stop all VIP-dependent cluster components on one node, make the necessary changes in DNS, change the VIP using SRVCTL, restart all VIP-dependent components, and then perform these steps on al the remaining nodes one at a time.
• E. Stop all VIP-dependent components on all cluster nodes, make the necessary changes in DNS, and then restart all VIP-dependent components.