Oracle Database 10g R2: Administering RAC Sample Questions:

1. You are asked to investigate a problem regarding client connectivity between the HR service and a database, which is on a four-node RAC cluster. The HR service has four preferred instances on the RAC cluster. This cluster also supports five other services. Occasionally, a client-connect request for the HR service takes several minutes to connect, whereas the other five services connect within a second or two. Client-side and server-side connection load balancing are used for all the services. Which combination of network settings would explain these symptoms? (Choose two.)

A) The TNSNAMES. ORA file has an entry for the five other services that use the hostnames for the Virtual IP addresses and all the listeners listen on both the Public and Virtual IP addresses.
B) The TNSNAMES.ORA file has an entry for the HR service that uses only the host name for the public IP address, and all the listeners listen on both the Public and Virtual IP addresses.
C) The TNSNAMES. ORA file has an entry for all six services that uses the host name for the Public IP address and not the Virtual IP address.
D) The listener on one or more nodes is listening on both the Public IP address and the Virtual IP address, and the HR TNSNAMES entry uses the Virtual IP address.
E) The listener on one or more nodes is listening only on the Virtual IP address and the HR TNSNAMES entry uses the Hostnames for the Virtual IP addresses.

2. View the Exhibit and examine a database software installation step in a RAC environment.
Which statement about the path is true?

A) You must specify the same path where Oracle clusterware is installed.
B) You should specify the same path that you specified for the ORACLE_BASE environment variable.
C) You must specify the same path that you specified to install ASM.
D) You should specify a path under ORACLE_BASE where Oracle product is to be installed.
E) You must specify the location of Oracle inventory.
F) You must specify the location of the OCR file.

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

4. You are the administrator of a Linux-based Oracle cluster. To meet your company's disaster recovery requirements, you have to make backups of the OCR to a tape device. What are your options? (Choose all that apply.)

A) Use RMAN to back up the OCR from disk to tape.
B) Use the Linux DD command to write the OCR directly to tape.
C) Use your favorite tape backup command to back up the OCR from disk to tape.
D) Use your favorite tape backup command to back up the physical OCR backups from disk to tape.
E) Use the OCRCONFIG command to have CRSD write the OCR backup to tape for you.

5. Which statement regarding Clusterware is false? (Choose the false statement.)

A) The ORA_CRS_HOME directory must not be the same as the ORACLEJHOME directory.
B) Oracle Clusterware is installed using the Oracle Universal Installer (OUI).
C) The Oracle Database 10g Clusterware stack is compatible with Oracle 9i Group Services (GSD) processes.
D) The installation of Oracle Clusterware is mandatory even if you have installed vendor-specific clusterware.

Solutions: