Oracle Database 10g R2: Administering RAC Sample Questions:

1. View the Exhibit.
You are asked to help a colleague to logically remove node NLEDUC2 from a RAC cluster
installation.
On observing the colleague's terminal, you notice the output as seen in the exhibit. Based on this,
which five additional steps would you recommend? Do not be concerned with the correct
sequence for the steps.
(Choose five.)

A) Check that the software has been removed from the database and ASM homes on NLEDUC2.
B) Check that the ONS configuration has been updated on the remaining node.
C) Remove the listener from NLEDUC2.
D) Stop and restart the nodeapps on NLEDUC1.
E) Check that the node has been removed from the database and ASM inventories.
F) Check that the database and ASM instances are all terminated on NLEDUC2.
G) Stop and restart the clusterware on NLEDUC1.
H) Remove the node from the clusterware.

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 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.
B) 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.
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 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. According to the Maximum Availability Architecture, which case is best?

A) Run two identical sites with a primary RAC database on the first site, and only a RAC physical standby database on the second site.
B) Run two identical sites with a primary RAC database on the first site, and RAC physical and logical standby databases on the second site.
C) Run two identical sites with a primary RAC database on the first site, and non-RAC physical and logical standby databases on the second site.
D) Run two identical sites with a primary RAC database on the first site, and only a RAC logical standby database on the second site.

4. Which four statements contain accurate information regarding RAC VIPs and application VIPs? (Choose four.)

A) A RAC VIP fails over if the listener fails.
B) It is recommended to share application VIPs among multiple applications.
C) A failed over application VIP does accept new connections.
D) It is not recommended to share a RAC VIP among several database instances.
E) It is not recommended to share an application VIP among several applications.
F) A failed over RAC VIP does accept new connections.
G) An application VIP fails over if the associated application fails over.
H) It is recommended to share a RAC VIP among several database instances.

5. Which three statements are correct regarding ASM instances in a RAC environment? (Choose three.)

A) ASM instances recognize their disks by looking at their headers.
B) ASM instances can use different values for ASM_POWER_LIMIT.
C) ASM instances must all have the same value for ASM DISKGROUPS.
D) ASM instances can mount different sets of disk groups.
E) ASM instances must all have the same value for ASM_DISKSTRING.

Solutions: