New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Oracle 1z0-068 Online Access

Page: 4 / 6
Total 152 questions

Oracle Database 12c: RAC and Grid Infrastructure Administration Questions and Answers

Question 13

Which method can be used to convert a single-instance Oracle 12c Database to a RAC Database?

Options:

A.

using DBCA to migrate the database to shared storage and then start one or more RAC database instances on the cluster

B.

using DBCA to create a template from the single-instance database and then to create a RAC database on the cluster using that template

C.

using the rconfig utility to create a template from the single-instance database and then using DBCA to create a RAC database on the cluster using that template

D.

using the rconfig utility to migrate the database to shared storage and then using DBCA to start one or more RAC database instances on the cluster.

Question 14

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

Options:

A.

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

B.

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

C.

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

D.

Stage the patch on the cluster nodes.

Question 15

Which two statements are true about clustered ASM instances? (Choose two.)

Options:

A.

An ASM instance must store its SPFILE in ASM.

B.

The ASM passwordfile can be stored in $GRID_HOME/dbs on local storage of a cluster node.

C.

The ASM passwordfile can be stored in a diskgroup that is accessible to all ASM instances.

D.

The SPFILE must be stored in $GRID_HOME/dbs on local storage of a cluster node.

E.

The SPFILE must be stored in a diskgroup that is accessible to all ASM instances.

Question 16

PROD1, PROD2 and PROD3 are three active instances of the PROD database.

Examine these commands executed on PROD1:

SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=200 SCOPE=MEMORY sid=’*’;

SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=100 SCOPE=MEMORY sid=’PROD1’;

Which statement is true?

Options:

A.

PARALLEL_MIN_SERVERS will be 200 for all instances of PROD.

B.

PARALLEL_MIN_SERVERS will be 100 for all instances of PROD.

C.

The second statement returns an error because this parameter must be identical for all instances.

D.

PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1.

Page: 4 / 6
Total 152 questions