Oracle Database 10g R2: Administering RAC Sample Questions:

1. Which three statements about Snapshot Control File Management in a RAC environment are true? (Choose three.)

A) RMAN parameters controlling snapshot control files can be configured from the Enterprise Manager Cluster Database home page.
B) You need to configure a default path and file name for these snapshot control files that is valid on every node from which you might initiate an RMAN backup.
C) By default, the snapshot control file is created on the node that is making the backup.
D) You can use a cluster file system or a raw device to store snapshot control files.

2. 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 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.
B) 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.
C) 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.
D) 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.
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.

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

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

4. Which three statements regarding backup of the voting disk are true? (Choose three.)

A) A backup of the voting disk should be taken whenever an RMAN catalog reset is done.
B) A backup of the voting disk should be taken whenever an existing node is removed from the cluster.
C) Whenever a voting disk backup is made, the Clusterware software should be stopped on all nodes in the cluster.
D) On UNIX platforms, the voting disk can be backed up with the dd command.
E) A backup of the voting disk should be taken whenever a new node is added to the cluster.

5. Which three statements about deleting instances from a RAC database on a UNIX platform are true? (Choose three.)

A) To delete an instance, start the DBCA on the node that hosts the instance that you want to delete.
B) To delete an instance, start the DBCA on a node other than the node that hosts the instance that you want to delete.
C) The DBCA can be used to delete an instance from a RAC database.
D) During a delete operation, the DBCA removes the instance and the instance Oracle Net configurationDuring a delete operation, the DBCA removes the instance and the instance? Oracle Net configuration.

Solutions: