Oracle Database 10g R2: Administering RAC Sample Questions:

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

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

2. Your company has certain standard practices for technology and you are configuring ASM disk groups for your four-node RAC cluster. The company guidelines suggest that there is one disk group for the flash recovery area that is shared by all databases and a separate disk group for the database area of all databases. Which three exceptions exist that may require you to create additional disk groups? (Choose three.)

A) Some databases operate in ARCHIVELOGMODE and others in NOARCHIVELOGMODE.
B) Some database instances are shut down every night while others are always running.
C) The disk farm has different disk models with different characteristics and ages.
D) Applications using the databases have different Service-Level Agreements for response time and throughput.
E) There are partitioned tables where the older partitions are in read-only tablespaces and seldom accessed, but the more recent partitions are frequently accessed.
F) The retention policy for backups are different for different databases.
G) There are large nonpartitioned tables accessed frequently using indexes.

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

4. You are preparing to create a RAC cluster. You review the RAC requirements for UNDO tablespaces. Which three are valid statements? (Choose three.

A) ALTER SYSTEM SET UNDO_TABLESPACE=undotbs3 SID='RDBD01'; is correct.
B) It is not necessary to assign a specific UNDO tablespace to a specific instance.
C) If no UNDO tablespace is available when the instance starts, the instance stores undo records in the SYSTEM rollback segments.
D) ALTER DATABASE SET UNDO_TABLEPACE=undotbs3 SID='RDBD01'; is correct.
E) You cannot assign a specific UNDO tablespace to a specific instance.

5. You decide to implement Fast Start Failover for your RAC Data Guard configuration to improve your high availability strategy. Which are the two valid locations for the DG Broker configuration files? (Choose two.)

A) on the local storage at the observer location
B) on the shared storage at the primary location
C) on the shared storage at the standby location
D) on the storage that is shared between the observer location and at least one of the instances that is part of the data guard configuration
E) on the shared storage at the observer location

Solutions: