Oracle Database 12c: RAC and Grid Infrastructure Administrator

Question 1

Which three statements are true about Oracle 12 RAC Database software installations?

A. It is possible to install multiple RAC database 12c software homes on the same cluster.

B. The Cluster Verification Utility (CLUVFY) must be used to check the cluster after installing the RAC database software.

C. The RAC database 12c software home and Grid Infrastructure homes must be owned by the same OS user.

D. The Cluster Verification Utility (CLUVFY) must be used to check the cluster before installing the RAC database software.

E. The RAC database 12c software home and Grid infrastructure homes must be owned by separate OS users.

F. It is possible to install RAC database software on a one node cluster.

Correct Answer: A,D,F

Question 2

Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 12c?

A. Stage the patch on the cluster nodes.

B. Update the PATH environment variable on the node where will run the OPatch utility to point to the
$ORACLE_HOME/OPatch directory.

C. Update the PATH environment variable on each cluster node to point to the $ORACLE_HOME/OPatch directory.

D. Stage the patch on the cluster node where the OPatch utility will be executed.

Correct Answer: B

Question 3

Which two steps must always be performed to delete node host04 from an Oracle 12c Clusterware cluster that does not use Grid Naming Service (GNS)?

A. Run the rootcrs.pl - deconfig -force command as root on host04.

B. Run the crsctl delete node -n host04 command as root on host04.

C. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.

D. Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.

E. Run the rootcrs.pl - deconfig -force command as root on host01, or on either host02 or host03.

F. Run the crsctl unpin css -n host04 command as root on host04

Correct Answer: A,C

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

Question 4

Which three are benefits of using RAC One Node in Oracle 12c?

A. online conversion from RAC One Node databases to multi-instance RAC databases

B. ability to perform rolling patches

C. automatic failover for high availability

D. online-conversion from non-RAC databases to RAC One Node databases

E. load-balancing of services within a single instance

F. multiple instances of the same database on a single node to protect against instance failure

Correct Answer: A,B,C

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

Question 5

You plan to apply a patchset to a RAC database running on a two-node cluster.
The cluster has this configuration:
* Grid infrastructure release 12.1.0.1.0
* RAC database release 12.1.0.1.0
* All software installed on local file systems
* The database is deployed on ASM disk groups.
Examine this list of possible tasks (see exhibit).
Exhibit:

Identify the required tasks in the correct order to apply the patchset with the least amount of down time.

A. 3, 2, 6 and 8

B. 3, 2, 5, 2 and 8

C. 3, 2, 5 and 8

D. 1, 2, 3, 5 and 8

E. 1, 3, 2, 5 and 8

Correct Answer: E

Question 6

Which two statements are true about database service administration in a RAC environment?

A. When services are started with srvctl, they are automatically added to the data dictionary of the hosting database if not already defined.

B. Service attributes can be modified, unless an instance hosting the service is in restricted mode.

C. When the DBMS_SERVICE package is used to delete a service, it is automatically removed from the OCR.

D. When services are created with srvctl, tnsnames.ora is automatically updated.

E. When the DBMS_SERVICE package is used to modify a service, the CRS resource is automatically synchronized with the changes.

F. When services are created with srvctl, the service is not started automatically.

Correct Answer: A,F

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

Question 7

Your flex cluster has these attributes:
1. Hub nodes host01 and host02
2. Leaf nodes host03 and host04
3. Full Featured GNS is configured and running.
You attempt to run this command to add two more nodes to the cluster:
$ ./addnode.sh -silent "CLUSTER_NEW_NODES={host05,host06}"
"CLUSTER_NEW_NODE_ROLES={hub,leaf}"
What is the result and the reason for this result?

A. It succeeds because no VIP specification is required for leaf nodes and none need to be specified for hub nodes when using full featured GNS.

B. It fails because no VIP was specified for the hub node host05.

C. It fails because hub and leaf nodes may not be added by the same execution of addNode.sh.

D. It fails because GNS doesn't assign VIPs for leaf nodes and no VIP was specified in the command.

Correct Answer: B

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

Question 8

You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2 and PDB_3.
Server pool prod_pool has a cardinality of three and all six hosts of the cluster app.
Examine these commands executed on HOST01:
$ srvctl add service -db CDB1 -pdb PDB_1 service AR -serverpool prod_pool -cardinality singleton
$ srvctl start service -db CDB1 -service AR
Which two statements are true regarding the AR service?

A. AR runs as a singleton service in the server pool prod_pool and the AR service is available in each of the CDB1 instances.

B. AR is available only on the CDB1 instance on HOST01.

C. AR can fail over to any other available CDB1 instance in prod_pool.

D. AR can fail over to any one of the available CDB1 instances.

E. AR is available on any one available CDB1 instance in prod_pool at any one time.

Correct Answer: C,E

Question 9

Which three statements are true concerning policy-based cluster management in Oracle 12c Clusterware?

A. Server Pools must be managed with the crsctl utility for servers hosting an application or other administrator-defined high-availability resource.

B. Server pools must be managed with the srvctl utility for servers hosting a database.

C. The server pool contains servers that host administrator-defined high availability resources.

D. All servers in a new cluster installation belong to the free server pool.

E. All servers in a new cluster installation belong to the generic server pool.

Correct Answer: B,C,D

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

Question 10

Which two are characteristics of any node that is part of a Grid Plug and Play (GPnP) Domain in Oracle Clusterware?

A. It has at least two nonroutable interfaces inside the GPnP domain for the private interconnect.

B. It has at least one routable interface inside the GPnP domain for the private interconnect.

C. It has a unique identifier that is unique inside the GPnP domain.

D. It has at least two routable interfaces outside the GPnP domain for the public interface.

E. It has a unique identifier that is unique outside the GPnP domain.

F. It has at least one routable interface outside the GPnP domain for the public interface.

Correct Answer: C,F

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

Question 11

Which three statements are true about Oracle Enterprise Manager Topology Viewer?

A. It displays the status of all cluster components.

B. It displays the relationship between targets of different target types in a cluster.

C. It displays the status of Pluggable Databases (PDBs) in a multitenant container database (CDB).

D. It displays the type of network used by RAC database instance.

E. It displays which listeners listen on behalf of which instances.

F. It displays the relationship between clustered ASM and cluster databases if the database is stored in ASM.

Correct Answer: B,E,F

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

Question 12

Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 12c Clusterware?

A. Set the environment variable _USA_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.

B. Use the crsctl set trace res "resource_name=debugging_level" command.

C. Use the cluvfy comp command for the specific resource within a component.

D. Use the crsctl set log res "resource_name=debugging_level2" command.

Correct Answer: B,D

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

Question 13

When installing Oracle Grid Infrastructure 12c, which three options exist for the configuration of Grid naming Service (GNS)?

A. using Shared GNS for the leaf nodes and local GNS for the hub nodes in a Flex Cluster

B. using Shared GNS for the hub nodes and local GNS for the leaf nodes in a Flex Cluster

C. using DHCP to assign Node Virtual IP addresses for nodes in the cluster

D. creation of a new GNS for this cluster

E. using Shared GNS running on another cluster

Correct Answer: A,C,D

Oracle Database 12c: RAC and Grid Infrastructure Administrator - 1z1-068 Exam Practice Test

Latest Update

Useful Links

Contact Us