Oracle 1Z0-048 問題集

質問 1：
Which two views can be used to identify SQL statements affected by interconnect latencies in your RAC environment? (Choose two.)
A. the VJSQLAREA view
B. the VJSQLTEXT view
C. the V$SQL_PLAN view
D. the VJSQL CURSOR view
E. the VJSQL view
正解：A,E

質問 2：
Your company is about to switch from one Internet Service Provider (ISP) to another, and this change of ISP comes along with a whole new set of network addresses. Your job is to change the VIP addresses of your company's Oracle Cluster.
How would you apply this change?
A. Stop all VIP-dependent components on all cluster nodes, make the necessary changes in DNS, and then restart all VIP-dependent components.
B. Stop all VIP-dependent cluster components on one node, make the necessary changes in DNS, change the VIP using SRVCTL, restart all VIP-dependent components, and then perform these steps on al the remaining nodes one at a time.
C. Change the VIP addresses on the cluster using SRVCTL while the cluster is fully functional.
D. Reinstall the Oracle Clusterware layer of your cluster.
E. Change the VIP addresses in DNS and the cluster would pick up the new addresses automatically.
正解：B

質問 3：
After migrating from a 10g R1 cluster to 10g R2, you decide to multiplex your voting disk. Which are the two ways in which you can accomplish this task? (Choose two.)
A. You must add additional voting disks offline.
B. You can add additional voting disks online.
C. You may use the VIPCA utility to add new voting disks.
D. You may use the command:
crsctl add ess votedisk <new voting disk path>
E. You should not use symbolic links.
正解：B,D

質問 4：
You need to add a new service to your RAC database, called DBA, to account for all the work done by database administrator sessions performing routine maintenance, to make this visible in the v$service_stats view. The maintenance would be done at quieter times but restricted session is not an option due to round-the-clock access requirements. The database administration team may connect locally or remotely to the RAC database. You decide to use DBCAto create the new service.
What must be true to allow client-server connection to the DBA service? (Choose two.)
A. All the listeners must be reloaded using LSNRCTL RELOAD to recognize the dynamically created service.
B. The TNSNAMES.ORAfile or a name server must contain the net service entries for the DBA service.
C. The services must be started using the SRVCTL START SERVICE command.
D. The ALTER SYSTEM REGISTER command must be used to induce PMON to register the service with the listeners.
E. The service must be started using the DBMS_SERVICE.START_SERVICE procedure.
F. The service must have at least one preferred or available instance that is running and accepting logins.
正解：B,F

質問 5：
Read the following statements about the ASM and OCFS file systems:
1) t is compatible with Oracle 9i and Oracle 10g.
2) t is one of the solutions for managing Oracle binaries in a RAC environment.
3) t relies on storage hardware or host-based RAID functionality to support high availability.
4) t is a shared storage file system designed to eliminate the need for raw partitions to store
certain files.
5) t is has integrated volume management with superior extent-based striping and mirroring.
6) t is a cluster file system with a volume manager built into the Oracle 10g kernel to manage
Oracle database files.
Identify the correct grouping where Group A represents true statements about ASM and Group B
represents true statements about OCFS.
A. Group
B. Group A: 5 6 Group B: 1 2,3,4
C. 1 5,6
D. 3 4 Group
E. 2 3,4 Group
F. 1 3,4 Group B: 3 4,5
G. Group
H. Group
I. 1 2,5,6
正解：B,C

質問 6：
Your four-node RAC cluster is no longer coping with workloads for one of its databases at peak periods and you decide to add another node to the cluster. The current configuration has two RAC databases, each with four instances with only the second database using ASM as a clustered database file system. ASM is installed in a separate home. Which five steps must you take to add all the software components and processes to the new node before you run DBCAto add database and ASM instances on the new cluster nodes. Do not be concerned with the correct sequence for the steps. (Choose five.)
A. Run addNode.sh in the ASM home/oui/bin directory from one of the existing nodes.
B. Run addNode.sh in the RDBMS home/oui/bin directory from one of the existing nodes.
C. Run cluvfy stage -pre crsinst <list of all nodes> from one of the existing nodes to verify the cluster configuration.
D. Run addnode.sh in the Clusterware home/oui/bin directory from each of the existing nodes once to define the new node to each existing node.
E. Run addnode.sh in the Clusterware home/oui/bin directory from one of the existing nodes to define the new node to all existing nodes.
F. Run netca from the new node to add a listener to the new node.
G. Run racgons add_config from one of the existing nodes to add the ONS metadata to the OCR.
正解：A,B,E,F,G

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

質問 8：
To install Oracle Database 10g RAC on a UNIX platform, which four directories will you identify for use? (Choose four.)
A. Oracle inventory directory
B. Oracle home directory (ORACLE_HOME)
C. group services directory (GSDJHOME)
D. CRS home directory (ORA_CRS_HOME)
E. Oracle base directory (ORACLE_BASE)
F. NET_ADMIN directory
正解：A,B,D,E