"A script enabled browser is required for this page to function properly"

Oracle Certification

Oracle Database 10g R2: RAC for Administrators

Sample Questions

View answers below

Sample questions are provided solely to familiarize candidates with the multiple-choice format and writing style of questions that will be found on the exam. Sample questions may not cover the full spectrum of difficulty that is covered by the exam questions. Success on the sample questions does not predict success on the exam.

1. Examine the following points about Voting File and OCR File:
  1. It is recommended to store it in ASM
  2. The best practice is to store it in raw devices or raw volumes on the fastest I/O disks
  3. Clusterware uses this file to track node membership in the cluster
  4. It must be stored in the same location set for ORACLE_HOME
  5. It is a file that is used to configure Cluster Verification Utility (CVU)
Which option has the correct points listed?
  1. OCR File: a, e
  2. OCR File: d, e
  3. Voting File: b, c
  4. Voting File: a, c, d
2. You are working in a RAC environment that has three instances RAC01, RAC02, and RAC03 started. You executed the following commands on the RAC02 instance:

CONNECT / @RAC02 AS SYSDBA
SHUTDOWN TRANSACTIONAL

What would be the effect of this command on the RAC environment?
 
  1. It will shut down the RAC02 instance after all the transactions in all the instances have either committed or rolled back. Then it will close the RAC database for access from all the instances
  2. It will shut down the RAC02 instance after all the transactions in all the instances have either committed or rolled back. It will not close the RAC database for access from RAC01 and RAC03 instance
  3. It will shut down the RAC02 instance after all the transactions in the current instance have either committed or rolled back. Then it will close the RAC database for access from all the instances
  4. It will shut down the RAC02 instance after all the transactions in the current instance have either committed or rolled back. It will not close the RAC database for access from any instances
3. Compare the initialization parameter settings shown below for the RAC01 and RAC02 instances

RAC01 Instance RAC02 Instance
   
DB_NAME=RACDB DB_NAME=RACDB
DB_BLOCK_SIZE=8192 DB_BLOCK_SIZE=8192
COMPATIBLE=10.2.0 COMPATIBLE=10.1.0
UNDO_MANAGEMENT=AUTO UNDO_MANAGEMENT=MANUAL
OPEN_CURSORS=250 OPEN_CURSORS=300

Which parameter setting might create problems in this RAC environment? (Choose all that apply)
  1. COMPATIBLE
  2. OPEN_CURSORS
  3. DB_BLOCK_SIZE
  4. UNDO_MANAGEMENT
4. Which statements are true regarding the flash recovery area in a RAC environment? (Choose all that apply)
  1. It can be placed in ASM
  2. It can be placed in a cluster file system
  3. It is instance specific so must be stored on a local file system
  4. It can be configured only if RMAN Recovery Catalog is already configured
  5. It is effective only if DB_RECOVERY_FILE_DEST_SIZE parameter is set to different values in all the instances

5. You added a service in your RAC environment using the following command:

$ srvctl add service -d PROD -s PRD -r RAC01,RAC02 -a RAC03,RAC04

After the service is added the RAC02 instance fails and goes down. The Oracle Clusterware detects RAC02 instance failure and restores the service on the RAC03 instance. The connection requests to PRD are directed to RAC01 and RAC03 instead of RAC01 and RAC02.

What would happen when Oracle Clusterware restarts the RAC02 instance? (Choose all that apply)
  1. The PRD service will fall back to RAC02 instance immediately
  2. The PRD service will fall back to RAC02 if any other failure occurs
  3. The PRD service will fall back to RAC02 if you use SRVCTL to relocate the service
  4. The PRD service cannot fall back to an instance once it is failed until the service is re-created

6. You executed the following command to modify the service configuration:

srvctl modify service -d PROD -s SDW -n -i I1,I2,I3,I4 -a I5,I6

Which two statements are true about this command? (Choose two)
  1. The modifications to the service take effect immediately
  2. The -n option disconnects all the sessions of all the instances
  3. The -n option makes the service to restart automatically after modifications
  4. The modifications to the service take effect when the services are next restarted
  5. It modifies the service SDW to make instances I5 and I6 as preferred instances
  6. It modifies the service SDW to make instances I1, I2, I3 and I4 as preferred instances

7. Examine the following connect string:
MYCON =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=ON)
(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=m1vip)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=m2vip)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=TECH.US.ORACLE.COM)))

How is this string used by client connections?
  1. The connections are attempted always to the first address
  2. The connections will be made to the node with the lowest workload
  3. The connections are attempted to the addresses in a random sequence
  4. The connections will be made to the instance where there are fewest connections using the service TECH.US.ORACLE.COM

8. Following are tasks that are performed as part of the process of adding a new node to the RAC environment:

Running the rootnodeadd.sh script in the first node
Executing the racgons add_config command

Identify the purpose of these two tasks. (Choose two)
  1. These tasks add and configure a database instance to the new node
  2. These tasks add the nodeapps of the new node to the OCR configuration
  3. These tasks make sure that the ONS on the first node can communicate with the ONS on the new node
  4. These tasks start the Oracle Clusterware stack on the new node and then run VIPCA in silent mode for configuring nodeapps

9. Which statement correctly describes the process of patching RAC using a rolling method (rolling patch) of OPatch?
  1. It patches each node without shutting down the instance in the node
  2. It patches each node while all the other nodes are up and running, resulting in no disruption of the system
  3. It patches the local node, patches a subset of nodes, propagates the patch to the other nodes and finally updates the inventory. No instances will be shut down during this entire process
  4. It applies the patch to the local node first, propagates the patch to all the other nodes, and updates the inventory. All the instances are down during this entire process

Answers

  1.  C
  2.  B
  3.  AD
  4.  AB
  5.  BC
  6.  DF
  7.  C
  8.  BC
  9.  B