Oracle 1Z0-048 問題集

質問 1：
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

質問 2：
Which three statements regarding backup of the voting disk are true? (Choose three.)
A. On UNIX platforms, the voting disk can be backed up with the dd command.
B. Whenever a voting disk backup is made, the Clusterware software should be stopped on all nodes in the cluster.
C. A backup of the voting disk should be taken whenever a new node is added to the cluster.
D. A backup of the voting disk should be taken whenever an existing node is removed from the cluster.
E. A backup of the voting disk should be taken whenever an RMAN catalog reset is done.
正解：A,C,D

質問 3：
Which three statements about Snapshot Control File Management in a RAC environment are true? (Choose three.)
A. You can use a cluster file system or a raw device to store snapshot control files.
B. 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.
C. RMAN parameters controlling snapshot control files can be configured from the Enterprise Manager Cluster Database home page.
D. By default, the snapshot control file is created on the node that is making the backup.
正解：A,B,D

質問 4：
On a UNIX platform, which three processes are required to be running on all nodes before initiating a cluster database creation? (Choose three.)
A. evmd.bin
B. ocssd.bin
C. racgmon.bin
D. crsd.bin
正解：A,B,D

質問 5：
Which three statements about patching Oracle products in a clustered environment are true? (Choose three.)
A. The OUI automatically manages the patch installation progress, including the copying of files to remote nodes, just as it does with the CRS and database binary installations.
B. OUI prevents potentially destructive concurrent patch installations through the use of Inventory List Locks.
C. The Oracle Universal Installer (OUI) is cluster-aware and able to manage patches on all nodes in your cluster.
D. OUI manages patches in a clustered environment only if a shared ORACLEJHOME is employed.
正解：A,B,C

質問 6：
Your storage administrator informs you about some disk corruption issues in the disk subsystem where your Oracle Cluster Registry (OCR) is located. Your storage administrator has resolved these corruption issues by applying a patch to the storage subsystem, but to be sure that the OCR is not affected by this problem the administrator wants you to check the integrity of the OCR. How would you do this?
A. You create a logical export from the OCR by using the OCRCONFIG command and analyze the export file for errors.
B. You create a physical backup of the OCR by using the OCRCONFIG command, and if this succeeds without errors you know that the OCR is not corrupted.
C. There is no easy way to check your OCR for corruptions.
D. You dump the OCR contents into a text file by using the OCRDUMP command, and if that succeeds without errors you know that your OCR is not corrupted.
E. You can check whether the OCR is not corrupted by using the OCRCHECK command.
正解：E

質問 7：
You observe a high number of gc current failure on your RAC system. What could be causing this issue?
A. You are not using the correct private interconnect.
B. Too much manual locking is occurring.
C. There is too much contention on the High Water Mark enqueue of your tables.
D. Too much parsing is occurring on your system.
正解：A

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