Oracle Database 10g R2: Administering RAC 認定 1Z0-048 試験問題:

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

A) The DBCA can be used to delete an instance from a RAC database.
B) 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.
C) To delete an instance, start the DBCA on the node that hosts the instance that you want to delete.
D) To delete an instance, start the DBCA on a node other than the node that hosts the instance that you want to delete.

2. You have a four-node cluster with instances RDBD1, RDBD2, RDBD3, and RDBD4. While evaluating statspack reports, you find nq: TX- index contention on page one under the category op 5 Timed Events.
Further study finds an unusually high number of c buffer busy waits in the Wait Events section. Checking the Instance Activity Stats section, you see an unusually high value for eaf Node Splits. Using v$segment_statistics, you identify that the top segment with c buffer busy waits is the index prooducts_pk, which obtains the primary key from a sequence. You wish to present alternative solutions to the team to help reduce contention.
Which three actions would you recommend to reduce the overheads? (Choose three.

A) Re-create the index as a global hash partitioned index.
B) Set _lm_msg_batch_size to a higher value.
C) Set fast_start_mttr_target to a higher value.
D) Re-create the table using a natural key instead of a surrogate key.
E) Increase the sequence cache size if retaining the sequence.
F) Encourage shorter transactions.

3. Which three statements about quiescing a RAC database are true? (Choose three.)

A) The ALTER SYSTEM QUIESCE RESTRICTED and ALTER SYSTEM UNQUIESCE statements affect all instances in a RAC environment.
B) Use the ALTER SYSTEM QUIESCE RESTRICTED statement from a single instance.
C) It is possible to take a cold backup while the database is in a quiesced state.
D) The database cannot be opened from another instance until the ALTER SYSTEM QUIESCE?statement finishes execution.

4. The following are some of the tasks that are performed during a RAC implementation: 1) Setting the Oracle database-related environment variables 2) Creating a password file 3) Installing Management Service and Management Agent 4) Creating and editing the Raw Device Mapping file 5) Creating an ASM instance 6) Creating the Oracle Cluster Registry (OCR) file 7) Implementing the Transparent Application Failover (TAF) policy 8) Creating database services Identify the tasks that can be performed using the DBCA, or performed by the DBCA, during database creation in the RAC implementation.

A) 1,3,4,6
B) 2,3,5,7,8
C) 1,2,3,5,6,8
D) All the tasks
E) 2,3,4,6,7

5. Which two initialization parameters must be set to start up an ASM instance in a RAC environment? (Choose two.)

A) B_UNIQUE_NAME
B) INSTANCE_TYPE
C) ASM_DISKSTRING
D) CLUSTER DATABASE
E) ASM_POWER_LIMIT
F) ASM_DISKGROUPS

質問と回答：