Your company asked you to implement RAC to enhance the scalability and availability of the database that you manage. Your coworker suggested that you use ASM as the only storage option. However, you implemented RAC with Automatic Storage Management (ASM) as well as OCFS as storage options. What are the reasons for implementing both OCFS and ASM as storage options? (Choose all that apply.)

• A. You do not want to use raw devices to store voting and OCR files.
• B. You want to avoid keeping Oracle binaries on local storage.
• C. You want to use the Oracle Managed Files (OMF) feature but that is not supported by ASM.
• D. You do not want to store any file other than voting and OCR files in ASM.
• E. You require OCFS to store archive log files because ASM does not support these files.

Which three tools can you use to patch your RAC database? (Choose three.)

• A. dbca
• B. emctl
• C. emca
• D. opatch
• E. Oracle Universal Installer
• F. EM Database Control

The following query shows four MEMBER disks and three CANDIDATE disks.
SQL> select name, header_status, path from v$asm_disk;
NAME HEADER STATUS PATH
CANDIDATE /dev/rdsk/diska5
CANDIDATE /dev/rdsk/diska6
CANDIDATE /dev/rdsk/diska7
DISK01 MEMBER /dev/rdsk/diska1
DISK02 MEMBER /dev/rdsk/diska2
DISK03 MEMBER /dev/rdsk/diska3
DISK04 MEMBER /dev/rdsk/diska4
7 rows selected.
Using SQLPIus you want to add /dev/rdsk/diska5 and /dev/rdsk/diska6 to diskgroup DGROUP1
DGROUP1 is currently mounted.
Pick the statement that would fail to add diska5 and diska6.

• A. ALTER DISKGROUP dgroupl ADD DISK
  '/dev/rdsk/diska5' name disk05,
  '/dev/rdsk/diska6' name disk06;
• B. ALTER DISKGROUP dgroupl ADD DISK '/dev/rdsk/disk*5', '/dev/rdsk/disk*6';
• C. ALTER DISKGROUP dgroupl ADD DISK
  '/dev/rdsk/diska5',
  '/dev/rdsk/diska6';
• D. ALTER DISKGROUP dgroupl ADD DISK '/dev/rdsk/diska[56]';
• E. ALTER DISKGROUP dgroupl ADD DISK '/dev/rdsk/diska*';

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

Which statement is true regarding undo management in a RAC environment?

• A. You cannot mix automatic undo management and manual undo management.
• B. A RAC database contains one undo tablespace shared by all instances.
• C. A RAC database must have defined only one undo tablespace for each instance.
• D. It is possible to store undo tablespaces on nonshared disks.