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：
While creating a new service inside your ORCL database, you encounter a problem during the execution of the srvctl add service command. Because you are unable to explain the reason for this failure, you decide to log a service request in Oracle Metalink. You want to make this service request as complete as possible. You want to create a trace file from your problematic srvctl command execution so that Oracle Support has all possible information to quickly identify and resolve your problem. How do you create a Java-based tool trace file?
A. Request extra information by adding the -d (debug) command-line flag at the srvctl command line.
B. Set the SRVM_DEBUG environment variable to TRUE before you execute the srvctl command.
C. Request extra information by adding the -v (verbose) command-line flag at the srvctl command line.
D. Set the SRVM_TRACE environment variable to TRUE before you execute the srvctl command.
E. Set the DEBUG environment variable to TRUE before you execute the srvctl command.
正解：D

質問 3：
You define the ERP service using this statement:
srvctl add service -d RACDB -s ERP -r RAC01 -a RAC02 -P PRECONNECT srvctl start service -d
RACDB -s ERP
You then use this connect string to connect to your RAC instances:
ERP =
(DESCRIPTION =(FAILOVER=ON)(LOAD_BALANCE=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=N1 VIP)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=N2VIP)(PORT=1521))
(CONNECT_DATA = (SERVICE_NAME = ERP)
(FAILOVER_MODE =
(BACKUP=ERP_PRECONNECT)(TYPE=SESSION)(METHOD=PRECONNECT))))
You successfully establish a connection to your RAC database using the above connect string.
How many connections are established, and on which instances?
A. one on RAC01 and one on RAC02
B. two on RAC02
C. only one on RAC01
D. two on RAC01
正解：A

質問 4：
You decide to implement Fast Start Failover for your RAC Data Guard configuration to improve your high availability strategy. Which are the two valid locations for the DG Broker configuration files? (Choose two.)
A. on the storage that is shared between the observer location and at least one of the instances that is part of the data guard configuration
B. on the shared storage at the observer location
C. on the local storage at the observer location
D. on the shared storage at the primary location
E. on the shared storage at the standby location
正解：D,E

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

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

質問 7：
View the Exhibit and examine a database software installation step in a RAC environment.
Which statement about the path is true?

A. You must specify the location of the OCR file.
B. You should specify a path under ORACLE_BASE where Oracle product is to be installed.
C. You should specify the same path that you specified for the ORACLE_BASE environment variable.
D. You must specify the same path that you specified to install ASM.
E. You must specify the same path where Oracle clusterware is installed.
F. You must specify the location of Oracle inventory.
正解：B

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