Oracle Database 10g R2: Administering RAC Sample Questions:

1. After migrating from a 10g R1 cluster to 10g R2, you decide to multiplex your voting disk. Which are the two ways in which you can accomplish this task? (Choose two.)

A) You should not use symbolic links.
B) You may use the VIPCA utility to add new voting disks.
C) You may use the command:
crsctl add ess votedisk <new voting disk path>
D) You must add additional voting disks offline.
E) You can add additional voting disks online.

2. View the Exhibit.
Users complain about the performance of an Oracle database-based application. You are requested to investigate. From Grid Control, you immediately infer that one of the cluster database instances and one of the cluster ASM instances are currently unavailable. You also see that the host where the instance belongs was recently rebooted due to an unknown reason.
Using Grid Control, you restart the instance and performance rapidly improves. You want to determine the cause of the instance startup failure after system boot, and you check the resource profiles on both the database and ASM instances involved.
Why was the instance not started by CRS?

A) The instance was started by CRS after the system was rebooted, but someone stopped it from within SQL*Plus.
B) The database instance could not be started by CRS because this instance depends on an ASM instance, whose autostart attribute indicates that CRS should not start this ASM instance after system boot.
C) The instance was not started by CRS because its target state was set to "offline" a while before the system was rebooted.
D) The database instance autostart attribute is set to a value, thus preventing CRS from starting it after a system reboot.
E) The instance was started by CRS but due to multiple instance failures CRS disabled the database instance, thereby preventing further restarts.

3. View the Exhibit.
You are required to support your Oracle RAC configuration using ASM and RAID technology. You plan to discuss the storage configuration with the storage technology team. They have proposed a configuration as shown in the exhibit with a separate set of LUNs for the data disk group and the flash recovery area disk group and a 500 KB stripe size in line with other non-Oracle LUNs. The Data disk group has four250G LUNs and the FRA disk group has four500G LUNS, both of which are mirrored.

A) Index Range Scans would cause I/O to many different physical disks.
B) The LUNs are not aligned with ASM Allocation Units, which may lead to I/O bottlenecks.
C) I/O to the flash recovery area disk group for backups may cause performance issues when full table scans are occurring during batch workloads.
D) Retention policies that require backups to be kept for long time periods may cause wasted space due to large allocation units.

4. You are about to bring your Web server under control of the Oracle Clusterware to make it highly available. Which actions do you need to perform to accomplish this task? (Choose all that apply.

A) Create an application VIP profile using crs_profile, register it with crs_register, set its permission with crs_setperm, and then start it using crs_start.
B) Once done, manage the Web server with SRVCTL
C) Create an application profile using crs_profile, register it with crs_register, set its permission with crs_setperm, and then start it with crs_start.
D) Write an action script that Oracle Clusterware would use to start, stop, and check the status of an application.
E) Have the system administrator create an application VIP at the operating system level for you to use with the application.

5. 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) 1, 2,4,5,6,7
B) 1, 3,4,6
C) 2, 5,7,8
D) 2, 5,6,7,8
E) 3, 4,6,7,8

Solutions: