Oracle Database 10g R2: Administering RAC Sample Questions:

1. After a power failure, you noticed that one of your cluster database instances did not start automatically, whereas all other instances came up successfully. What would you do to determine the precise cause for the instance startup failure? (Choose three.)

A) Reboot the node where the failing instance resides to check if the problem is persistent.
B) Check the alert.log file that belongs to the Oracle Clusterware software.
C) Check the resource state by using the CRS_STAT command.
D) Check for OCR corruptions by using the OCRCHECK command.
E) Enable extra debugging in the Oracle Clusterware software by using the CRSCTL command.
F) Check if the Oracle Clusterware is functional by using the CRSCTL command.
G) Check the alert.log file that belongs to the instance that did not start.

2. You are creating a database in your RAC implementation. You are using the DBCA to create the database, and you selected the Raw Devices Mapping file on one of the screens of the DBCA. What is the reason for selecting this file?

A) You want to set the appropriate raw partition for each database file.
B) You want to provide the DBCA with a list of all the storage devices that are currently bound to a raw interface.
C) You want the DBCA to bind the partitions to raw devices.
D) You want to configure an ASM diskgroup containing raw devices.

3. While creating a new service inside your ORCL database, you encounter a problem during the execution of the srvctl add service command. Because you are unable to explain the reason for this failure, you decide to log a service request in Oracle Metalink. You want to make this service request as complete as possible. You want to create a trace file from your problematic srvctl command execution so that Oracle Support has all possible information to quickly identify and resolve your problem. How do you create a Java-based tool trace file?

A) Set the SRVM_DEBUG environment variable to TRUE before you execute the srvctl command.
B) Set the DEBUG environment variable to TRUE before you execute the srvctl command.
C) Request extra information by adding the -d (debug) command-line flag at the srvctl command line.
D) Set the SRVM_TRACE environment variable to TRUE before you execute the srvctl command.
E) Request extra information by adding the -v (verbose) command-line flag at the srvctl command line.

4. 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.

5. For which two server metrics can you define thresholds for your services? (Choose two.)

A) LOGICAL_READ_PER_CALL
B) ELAPSED_TIME_PER_CALL
C) PHYSICAL_READ_PER_CALL
D) APPLICATION_WAIT_TIME
E) SQL EXECUTE ELAPSED TIME
F) CPU_TIME_PER_CALL

Solutions: