1Z0-048試験無料問題集（150題）「Oracle Database 10g R2: Administering RAC 認定」

出題：1

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 products_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. Encourage shorter transactions.

B. Set fast_start_mttr_target to a higher value.

C. Re-create the index as a global hash partitioned index.

D. Increase the sequence cache size if retaining the sequence.

E. Re-create the table using a natural key instead of a surrogate key.

F. Set _lm_msg_batch_size to a higher value.

正解：C,D,E 解答を投票する

出題：2

You are migrating a single-instance Oracle database to RAC. The data files and Flash Recovery Area would be migrated to ASM using the RMAN commands BACKUP AS COPY DATABASE and BACKUP RECOVERY AREA, and stored in an ASM diskgroups called +DB_DG and +FR_DG. The DB_CREATE_FILE_DEST parameter would be set to +DB_DG and the DB_RECOVERY_FILE_DEST parameter would be set to +FR_DG.
What are the three best options for the location of your archivelogs so that they may be used properly for recovery without DBA intervention? (Choose three.)

A. Local File System with each instance writing to a local location provided that the path names are identical on all nodes.

B. ASM diskgroup +FR_DG as specified for the Flash Recovery Area provided that the ASM diskgroup is mounted on all ASM instances.

C. ASM diskgroup +DB_DG as specified for the Database Area provided that the ASM diskgroup is mounted on all ASM instances.

D. Cluster File System with each instance writing to a separate location as long as they are in directories under the same mount point.

E. Cluster File System with each instance writing to a shared location.

F. Local File System with each instance writing to a local location provided that NFS read mount points are created to all other nodes with instances of the database.

正解：B,E,F 解答を投票する

出題：3

The infrastructure team at your company requires your advice on maximizing availability using Maximum Availability Architecture and any other features that will help reduce planned downtime both for database instances and for the availability of database objects which applications depend on. You are already running a four node RAC cluster to protect against instance and node failures. Which four would you recommend if they are not already implemented? (Choose four.)

A. use of ASM

B. use of the DBMS_REDEFINITION package

C. use of online index rebuild

D. use of freelists to manage space in table and index segments

E. use of segment shrinking to reorganize space in tables and indexes

F. a physical standby database for rolling upgrades

正解：A,B,C,E 解答を投票する

出題：4

You execute the following command from the first node of your cluster: crsctl add ess votedisk /dev/raw/raw9
However, you get an error message indicating that Oracle Clusterware stack is not started. Which command would you execute?

A. crsctl add ess votedisk /dev/raw/raw9 -force

B. crsctl enable crs Crsctl add ess votedisk /dev/raw/raw9 -force

C. crsctl start crs Crsctl add ess votedisk /dev/raw/raw9 -force

D. crsctl enable crs Crsctl add ess votedisk /dev/raw/raw9

E. crsctl start crs Crsctl add ess votedisk /dev/raw/raw9

正解：A 解答を投票する

出題：5

Which two statements regarding the installation of the Oracle 10g Database software are true? (Choose two.)

A. The Oracle Universal Installer (OUI) can detect the cluster hardware and allow the user to install the software on the local node or choose all nodes to install the software.

B. If the OUI does not display all of the available nodes in your cluster, check the viability of your cluster and its associated nodes by executing the chkcluster command from $ORA_CRS_HOME/bin directory.

C. The directory path for the Oracle 10g Database software must not be the same as the Oracle 10g Clusterware home directory.

D. The OUI does not support a RAC installation if the Standard Edition is chosen from the Installation Type page.

正解：A,C 解答を投票する

出題：6

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

A. 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.

B. You can use a cluster file system or a raw device to store snapshot control files.

C. By default, the snapshot control file is created on the node that is making the backup.

D. RMAN parameters controlling snapshot control files can be configured from the Enterprise Manager Cluster Database home page.

正解：A,B,C 解答を投票する

1Z0-048試験無料問題集「Oracle Database 10g R2: Administering RAC 認定」