Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure Administration (1Z0-058) Free Practice Test

Question 1

Which two statements are true regarding the Automatic Workload Repository (AWR) In a RAC environment?

A. The Manageability Monitor Processes (MMON) process gathers statistics every hour from every instance and creates an AWR snapshot and stores it In the SGA.

B. The MMON process gathers statistics from its' own instance and kicks off statistics collection form other instances every hour from other instances and creates an AWR snapshot which is written to the sysaux tablespace.

C. The AWR includes time model statistics based on time usage for activities displayed In the VSSYS_TIME_MODEL and VSSESS_TIHE_HODEL views.

D. The AWR is controlled by the statistics_level initialization parameter and it must be set to TYPICAL or BASIC

Correct Answer: B,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

The high availability services provided by Oracle Clusterware are used to protect Oracle resources, such as RAC database instances, RAC database services, and other components of the Oracle Grid Infrastructure, and non-Oracle resources as well.
Which two statements are true about the high availability capabilities of Oracle HA services?

A. HA services will only fail over a resource upon failure of the node where the resource was active.

B. ASM instances may be failed over if fewer than three nodes remain in the cluster, so that there are always at least three ASM instances available.

C. If a node fails, then all resources that were active on that node will be failed over to a surviving node if any exists.

D. RAC databases may have their instances failed over in some cases.

E. If a node fails, then cluster resources that were active on that node may be failed over to a surviving node if any exists, but local resources are not failed over.

Correct Answer: A,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

You are ready to add two new nodes called RACNODE5 and RACNODE6 to your existing four-node cluster using addNode.sh
You have run cluvfy -peer to check the new nodes against a reference node.
When you originally created the cluster, the network administrators chose to statically define the scan vip addresses in the corporate DNS server, and you installed the Oracle Grid Infrastructure without using GNS.
What is the correct way to silently add the nodes? r

A. addNode. sh -silent "CLUSTER_NEW_NODES= { RACNODES, RACNODE6 } " "CLUSTER_NEW_VlRTUAL_HOSTNAMES= RACNODE5-VIP, RACNODE6-VI P > "

B. addNode . sh -silent "CLUSTER_NEW_VIRTUAL_HOSTNAMES=<(RACNODES -VI P, RACNODE6-VIP) "

C. addNode . sh -silent "CLUSTER_NEW_nodes={ RACNODE5, RACNODEg > "

D. CLUSTER_NEW_NODES= {"RACNODE5, RACNODE6")

E. addNode.sh -silent -responseFile mynewnodes . txt With the response file containing only CLUSTER NEW VIRTUAL HOSTNAMES= { " RACNODE3-VI P , RACNODE4 -VI P >

F. addNode.sh -silent -responseFile mynewnodea . txt With the response file containing only

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

Choose four tools that can be used to create ASM disk groups.

A. SQL*Plus

B. CRSCTL

C. ASMCA

D. ASMCMD

E. Enterprise Manager

F. SRVCTL

Correct Answer: A,C,D,E

Question 5

You are managing RAC database with policy managed services. The database is started by using an SPILE.
Which two statements are true regarding initialization parameters In a RAC environment?

A. To change values for initialization parameters for an instance, you must log in to that instance.

B. All initialization parameters must have identical settings on all instances.

C. All instances in the cluster database use the same SPFILE.

D. All initialization parameters for all instances can be changed from any instance In a RAC database.

Correct Answer: C,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

You have defined two server pools.
One is called OLTP with MIN_SIZE=3, MAX_SIZE =5 and IMPORTANCE=3.
The other is called DSS with MIN_SIZE =2, MAX_SIZE =4 and IMPORTANCE =5.
Your cluster currently has four nodes with two nodes in each of the pools. A fifth node is added to the cluster. What is true about the server pool to which the node will be assigned?

A. The node will have the server assigned to the OLTP pool because the OLTP pool's MAX_SIZE is greater than MAX_SIZE of the DSS pool.

B. The node will have the server assigned to the OLTP pool because the OLTP pool's current size is less than its MIN_SIZE and the DSS pool has enough servers to equal its own MIN_SIZE.

C. The node will have the server assigned to the DSS pool because the current size is less than MAX_SIZE and the DSS pool has a greater importance than the OLTP pool.

D. The node will have the server assigned to the DSS pool on the basis of having a greater IMPORTANCE.

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure Administration (1Z0-058) Free Practice Test