Oracle 1Z0-048 問題集

質問 1：
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. All the tasks
B. 1,2,3,5,6,8
C. 2,3,5,7,8
D. 1,3,4,6
E. 2,3,4,6,7
正解：C

質問 2：
The following query shows four MEMBER disks and three CANDIDATE disks.
SQL> select name, header_status, path from v$asm_disk;
NAME HEADER STATUS PATH
CANDIDATE /dev/rdsk/diska5
CANDIDATE /dev/rdsk/diska6
CANDIDATE /dev/rdsk/diska7
DISK01 MEMBER /dev/rdsk/diska1
DISK02 MEMBER /dev/rdsk/diska2
DISK03 MEMBER /dev/rdsk/diska3
DISK04 MEMBER /dev/rdsk/diska4
7 rows selected.
Using SQLPIus you want to add /dev/rdsk/diska5 and /dev/rdsk/diska6 to diskgroup DGROUP1
DGROUP1 is currently mounted.
Pick the statement that would fail to add diska5 and diska6.
A. ALTER DISKGROUP dgroupl ADD DISK '/dev/rdsk/disk*5', '/dev/rdsk/disk*6';
B. ALTER DISKGROUP dgroupl ADD DISK '/dev/rdsk/diska[56]';
C. ALTER DISKGROUP dgroupl ADD DISK
'/dev/rdsk/diska5' name disk05,
'/dev/rdsk/diska6' name disk06;
D. ALTER DISKGROUP dgroupl ADD DISK
'/dev/rdsk/diska5',
'/dev/rdsk/diska6';
E. ALTER DISKGROUP dgroupl ADD DISK '/dev/rdsk/diska*';
正解：E

質問 3：
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. Set fast_start_mttr_target to a higher value.
B. Re-create the index as a global hash partitioned index.
C. Increase the sequence cache size if retaining the sequence.
D. Encourage shorter transactions.
E. Re-create the table using a natural key instead of a surrogate key.
F. Set _lm_msg_batch_size to a higher value.
正解：B,C,E

質問 4：
Which two statements regarding Oracle Clusterware are correct? (Choose two.)
A. The Oracle Database 10g CRS stack is compatible with Oracle 9i Group Services (GSD) processes.
B. The Oracle Database 10g version of the srvConfig.loc file is the ocr.loc file.
C. The installation of Oracle Clusterware is not necessary if you have already installed vendor-specific clusterware.
D. The Oracle9i srvConfig.loc file still exists for backward compatibility in Oracle Database 10g.
正解：B,D

質問 5：
Which two statements regarding the installation of the Oracle 10g Database software are true? (Choose two.)
A. 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.
B. The directory path for the Oracle 10g Database software must not be the same as the Oracle 10g Clusterware home directory.
C. The OUI does not support a RAC installation if the Standard Edition is chosen from the Installation Type page.
D. 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,D

質問 6：
In which two orders could you run the following commands to migrate your database to ASM?
(Choose two.)
1 SHUTDOWN IMMEDIATE;
2 SWITCH DATABASE TO COPY;
3 STARTUP NOMOUNT;
4 ALTER DATABASE OPEN;
5 ALTER DATABASE TEMPFILE '/u01/ORCL/temp1.dbf DROP;
6 ALTER SYSTEM SET db_create_file_dest='+DATA' SCOPE=SPFILE;
7 BACKUP AS COPY DATABASE FORMAT '+DATA';
8 ALTER TABLESPACE temp ADD TEMPFILE;
9 RESTORE CONTROLFILE FROM '/u01/ORCL7control1.ctl';
10 ALTER SYSTEM SET control_files=" SCOPE=SPFILE;
11 RECOVER DATABASE;
12 ALTER DATABASE MOUNT;
A. 1,2,10,3,5,4,11,6,7,8,9,12
B. 6,10,1, 9,3,12,7,2,11,4,5,8
C. 10,6,1, 3,9,12,7,2,11,4,8,5
D. 6,10,1, 3,9,12,7,2,11,8,4,5
E. 6,10,1, 3,9,12,7,2,11,4,8,5
正解：C,E

質問 7：
You are asked by the DBA team leader to consolidate three different Oracle databases, which supported three separate workloads, into one large three-instance RAC database on a three-node cluster. You also need to create a separate service to represent each workload type and support client-side load balancing. The CRM service has two preferred instances, the HR service has two, and the ORDERS service
has only one. Any instance may be used as an vailable instance for any service that is not
specified as a preferred service for that same instance. You decide to create three separate
entries in TNSNAMES.ORA.
Choose three options describing the number of entries you would have in each address list.
(Choose three.)
A. one entry for the address list for the ORDERS service for the listeners on the nodes containing the preferred instance for ORDERS
B. three entries in the address list for the ORDERS service pointing to the listeners on all three nodes
C. three entries in the address list for the HR service for the listeners on all three nodes
D. three entries in the address list for the CRM service for the listeners on all three nodes
E. two entries for the address list for the CRM service pointing to the listeners on the nodes containing the preferred instances for CRM
F. two entries for the address list for the HR service for the listeners on the nodes containing the preferred instances for HR
正解：B,C,D

質問 8：
When an ASM instance initializes, ASM discovers and examines the contents of all the disks that are in the paths designated in the ASM_DISKSTRING initialization parameter. Under which four other circumstances does disk discovery take place? (Choose four.)
A. when you query VJASMjDPERATION
B. when you query V$ASM_DISK
C. when you run ALTER DISKGROUP...ADD DISK
D. when you query V$ASM_DISKGROUP
E. when you run ALTER DISKGROUP...RESIZE DISK
正解：B,C,D,E