Oracle Database 10g R2: Administering RAC Sample Questions:

1. After the cluster database has been successfully created, several postinstallation tasks should be completed. Identify three of them. (Choose three.)

A) Back up the root.sh script.
B) Initialize the cluster backup procedure.
C) Create the ASM instance.
D) Verify the Enterprise Manager/Oracle Cluster Registry configuration by running srvctl config database -d db_name.
E) Set up additional required user accounts.

2. Which two statements regarding Oracle Clusterware are correct? (Choose two.)

A) The Oracle Database 10g CRS stack is compatible with Oracle 9i Group Services (GSD) processes.
B) The Oracle9i srvConfig.loc file still exists for backward compatibility in Oracle Database 10g.
C) The Oracle Database 10g version of the srvConfig.loc file is the ocr.loc file.
D) The installation of Oracle Clusterware is not necessary if you have already installed vendor-specific clusterware.

3. You decide to implement a Dataguard configuration for your RAC installation to support your disaster recovery architecture. There are two instances on the primary and two on the physical standby. Which are the two appropriate settings for the DG_BROKER_CONFIG_FILE1 and DG_BROKER_CONFIG_FILE2 initialization parameters? (Choose two.)

A) DG_BROKER_CONFIG_FILE1 set to a location shared between each primary database instance and DG_BROKER_CONFIG_FILE2 set to a different location shared between each primary database instance on the primary database cluster.
B) DG_BROKER_CONFIG_FILE1 set to a location shared between each standby database instance and DG_BROKER_CONFIG_FILE2 set to a different location shared between each standby database instance on the standby database cluster.
C) DG_BROKER_CONFIG_FILE1 set to a nonshared location for each secondary database instance and DG_BROKER_CONFIG_FILE2 set to a shared location for each secondary database instance on the secondary database cluster.
D) DG_BROKER_CONFIG_FILE2 set to the same shared location for the second instance of both the primary and the standby databases.
E) DG_BROKER_CONFIG_FILE1 set to the same shared location shared between the first instance of both the primary and the standby databases.
F) DG_BROKER_CONFIG_FILE1 set to a nonshared location for each primary database instance and DG_BROKER_CONFIG_FILE2 set to a shared location for each primary database instance on the primary database cluster.

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

5. You are working as a DBA in a RAC environment that is available for testing. The RAC environment has all the database files stored in the OCFS file system. You plan to install ASM and move all the database files to ASM to achieve better performance. During the installation, you selected redundancy level as normal for the disk group being added. What is the reason for selecting this redundancy level?

A) You have three failure groups defined, so you want to use three-way mirroring.
B) You have two failure groups defined, so you want to use two-way mirroring.
C) You do not want to have any mirroring in the disk group.
D) You want to use hardware mirroring.

Solutions: