Oracle Database 10g R2: Administering RAC - 1Z0-048 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

For which two server metrics can you define thresholds for your services? (Choose two.)

A. APPLICATION_WAIT_TIME B. CPU_TIME_PER_CALL C. SQL EXECUTE ELAPSED TIME D. PHYSICAL_READ_PER_CALL E. ELAPSED_TIME_PER_CALL F. LOGICAL_READ_PER_CALL

Discussion 0

Correct Answer: B,E Vote an answer

Question 2

Which background process communicates load information to its listener?

A. SMON B. LMON C. MMON D. PMON

Discussion 0

Correct Answer: D Vote an answer

Question 3

After the cluster database has been successfully created, several postinstallation tasks should be completed. Identify three of them. (Choose three.)

A. Create the ASM instance. B. Back up the root.sh script. C. Initialize the cluster backup procedure. D. Set up additional required user accounts. E. Verify the Enterprise Manager/Oracle Cluster Registry configuration by running srvctl config database -d db_name.

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 4

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

Discussion 0

Correct Answer: A,B,C,G,H Vote an answer

Question 5

To complete a cluster database creation, the DBA must choose the cluster database storage method. Which storage choice is not correct? (Choose the incorrect one.)

A. Raw Devices B. Standard UNIX file system C. Supported SAN/NAS storage D. Automatic Storage Management (ASM) E. Cluster File System

Discussion 0

Correct Answer: B Vote an answer

Question 6

You are implementing a three-node RAC setup in your company. You have already performed these tasks:
1) Hardware and OS configuration 2) Cluster file system installation 3) Clusterware installation You executed the following command in one of the nodes: cluvfy stage -pre dbinst -n all
What is the reason for executing this command?

A. to check if the ORACLEJHOME environmental variable is set to a correct value or not before the database installation B. to check for the existence of Oracle database software installation files in the /stage directory on all the nodes C. to check for node connectivity and Clusterware integrity D. to check whether the dbinst directory is available on all the nodes

Discussion 0

Correct Answer: C Vote an answer

Question 7

Which initialization parameter would you use for each RAC instance to make sure that each listener on each RAC node is aware of the load of all the others?

A. LOCALJJSTENER B. REMOTE_DEPENDENCIES_MODE " C. REMOTEJJSTENER D. PREFER LEAST LOADED NODE <listener-name>

Discussion 0

Correct Answer: C Vote an answer

Question 8

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. 6,10,1, 3,9,12,7,2,11,8,4,5 B. 6,10,1, 9,3,12,7,2,11,4,5,8 C. 6,10,1, 3,9,12,7,2,11,4,8,5 D. 1,2,10,3,5,4,11,6,7,8,9,12 E. 10,6,1, 3,9,12,7,2,11,4,8,5

Discussion 0

Correct Answer: C,E Vote an answer

Question 9

Your company has certain standard practices for technology and you are configuring ASM disk groups for your four-node RAC cluster. The company guidelines suggest that there is one disk group for the flash recovery area that is shared by all databases and a separate disk group for the database area of all databases. Which three exceptions exist that may require you to create additional disk groups? (Choose three.)

A. The retention policy for backups are different for different databases. B. The disk farm has different disk models with different characteristics and ages. C. Some database instances are shut down every night while others are always running. D. Some databases operate in ARCHIVELOGMODE and others in NOARCHIVELOGMODE. E. There are large nonpartitioned tables accessed frequently using indexes. F. There are partitioned tables where the older partitions are in read-only tablespaces and seldom accessed, but the more recent partitions are frequently accessed. G. Applications using the databases have different Service-Level Agreements for response time and throughput.

Discussion 0

Correct Answer: B,F,G Vote an answer

Question 10

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 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. B. 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. C. 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. D. 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. E. 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.

Discussion 0

Correct Answer: D,E Vote an answer