Oracle Database 10g R2: Administering RAC Sample Questions:

1. You are working with Oracle Support to resolve an issue regarding the Oracle Clusterware software. The Oracle support engineer wants you to upload all relevant CRS log and trace files.
How would you provide al the requested log and trace files?

A) Collect all required log and trace files using the diagcollection.plcommand and upload them to Oracle Support.
B) Upload each and every available log and trace files to Oracle Support.
C) Use Grid Control to collect and send all required log and trace files to Oracle Supporl.
D) Use an operating system command to create an archive with all the log and trace files stored in the ORA_CRS_HOME/log directory and upload the files to Oracle Support.

2. Which two views can be used to identify SQL statements affected by interconnect latencies in your RAC environment? (Choose two.)

A) the VJSQLAREA view
B) the V$SQL_PLAN view
C) the VJSQL CURSOR view
D) the VJSQLTEXT view
E) the VJSQL view

3. View the Exhibit and examine the diagram of the RAC environment implemented on a Linux platform in your company.
As a senior DBA, you have been assigned the task to implement ASM in this environment. You configured the raw devices that you plan to add to the ASM disk group.
How would you create an ASM instance on each node? (Choose all that apply.)

A) by using the oracleasm configure command on both the nodes
B) by using Oracle Universal Installer (OUI) on any one of the nodes
C) by using the oracleasm configure command on any of the nodes
D) by using the ASMCMD command-line utility on both the nodes
E) by using DBCA on all nodes
F) by using Database Configuration Assistant (DBCA) on any one of the nodes

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

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

5. What does server-side Connect-Time Load Balancing do to complement the client-side Connect-Time Load Balancing function of balancing the connection requests to all the listeners in the address list on the client side?

A) it balances the load for each service across all preferred instances for that service, according to the service-specific load-balancing requirements,
B) it balances the load for each service across all instances for that service, according to the service-specific load-balancing requirements,
C) it balances the load for each service across all preferred instances for all services, according to the service-specific load-balancing requirements,
D) it balances the load for each service across all available instances for that service, according to service-specific load-balancing requirements,
E) it balances the load for each service across all preferred instances for that service, according to the global load-balancing requirements.

Solutions: