Oracle 1Z0-048 問題集

質問 1：
You have a well-tuned, non-RAC single instance Oracle database with several services, all of which perform perfectly. You plan to migrate the database to RAC in the next two weeks and all file systems would be shared using Oracle Cluster File System. After the migration, you want to perform a test to monitor RAC-specific tuning issues that would not have occurred on a non-RAC database. Which six areas would you monitor to determine whether there are RAC-specific performance problems after migration? (Choose six.)
A. Services with applications that use external tables
B. Services with applications that truncate large tables
C. Instance recovery time
D. Services with query-intensive applications relying on full table scans
E. Interconnect latency
F. Services with insert-intensive applications that generate their own keys without Oracle sequences
G. Services with applications that have occasional queries, using index access on modestly sized tables
H. Services with insert-intensive applications that use Oracle sequences for index keys
I. Services with applications using local context variables
正解：B,C,D,E,F,H

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

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

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

質問 5：
After a power failure, you noticed that one of your cluster database instances did not start automatically, whereas all other instances came up successfully. What would you do to determine the precise cause for the instance startup failure? (Choose three.)
A. Enable extra debugging in the Oracle Clusterware software by using the CRSCTL command.
B. Check if the Oracle Clusterware is functional by using the CRSCTL command.
C. Reboot the node where the failing instance resides to check if the problem is persistent.
D. Check for OCR corruptions by using the OCRCHECK command.
E. Check the alert.log file that belongs to the Oracle Clusterware software.
F. Check the alert.log file that belongs to the instance that did not start.
G. Check the resource state by using the CRS_STAT command.
正解：E,F,G

質問 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 are asked to investigate a problem regarding client connectivity between the HR service and a database, which is on a four-node RAC cluster. The HR service has four preferred instances on the RAC cluster. This cluster also supports five other services. Occasionally, a client-connect request for the HR service takes several minutes to connect, whereas the other five services connect within a second or two. Client-side and server-side connection load balancing are used for all the services. Which combination of network settings would explain these symptoms? (Choose two.)
A. The TNSNAMES.ORA file has an entry for the HR service that uses only the host name for the public IP address, and all the listeners listen on both the Public and Virtual IP addresses.
B. The TNSNAMES. ORA file has an entry for the five other services that use the hostnames for the Virtual IP addresses and all the listeners listen on both the Public and Virtual IP addresses.
C. The listener on one or more nodes is listening only on the Virtual IP address and the HR TNSNAMES entry uses the Hostnames for the Virtual IP addresses.
D. The listener on one or more nodes is listening on both the Public IP address and the Virtual IP address, and the HR TNSNAMES entry uses the Virtual IP address.
E. The TNSNAMES. ORA file has an entry for all six services that uses the host name for the Public IP address and not the Virtual IP address.
正解：A,B

質問 8：
After a disk failure caused by a power outage, your CRS is unable to start up completely because all your OCR files are lost. Which commands would you use and in which order to redress this
situation?
1 OCRCONFIG -REPAIR (on the local cluster node only)
2 OCRCONFIG -REPAIR (on all cluster nodes)
3 OCRCONFIG -RESTORE <path name>
4 OCRCONFIG -IMPORT <path name>
5 CRSCTL STOP CRS (on the local cluster node only)
6 CRSCTL STOP CRS (on all cluster nodes)
7 OCRCONFIG -SHOWBACKUP
8 CRSCTL START CRS (on the local cluster node only)
9 CRSCTL START CRS (on all cluster nodes)
A. 7,6,4,9.
B. 7,6,3,2,9.
C. 7,6,3,9.
D. 5,3,8.
E. 5,4,8.
F. 6,4,9.
G. 6,3,9.
正解：C