Oracle Oracle Database 1Z0-068 Questions & Answers

• Question 21:

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

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

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

  C. Run the rooccrs.pl -deconfig -force command as root on host04.

  D. Run the crsct1 unpin css - host04 command as root on host04.

  E. Run the crsct1 delete node -n host04 command as root on host04.

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

  Correct Answer: AB

  Section: (none)

  Reference: https://docs.oracle.com/database/121/CWADD/adddelclusterware.htm#CWADD90995

• Question 22:

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

  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 directory. $ORACLE_HOME/OPatch

  D. Stage the patch on the cluster nodes.

  Correct Answer: C

  Section: (none)

• Question 23:

  Which two statements are true concerning the installation of Oracle Grid Infrastructure 12c when using a Standard Cluster? (Choose two.)

  A. The Clusterware binaries may be installed without installing ASM binaries.

  B. The Grid Infrastructure Management Repository is only required when using ASM.

  C. Specifying the use of Grid Naming Service is optional.

  D. Normal Redundancy ASM Disk Groups used for Clusterware flies will contain three voting files regardless of the number of failgroups.

  E. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.

  Correct Answer: AD

  Section: (none)

• Question 24:

  You plan to use DBCA to convert a single-instance Oracle 12c database on a local filesystem on a stand- alone server to RAC by using ASM.

  You installed Grid Infrastructure 12c on a four-node cluster.

  Examine this list of possible conversion steps:

  1.

  Create a template and image files from the single-instance database by using DBCA.

  2.

  Perform an RMAN backup of the single-instance database.

  3.

  Validate the cluster using CLUVFY.

  4.

  Copy the template and image files to a cluster node.

  5.

  Restore the RMAN backup to the recovery area disk group on the cluster.

  6.

  Perform an Oracle Database 12c RAC installation.

  7.

  Create a RAC database with DBCA using the RMAN backup.

  8.

  Create a RAC database with DBCA using the template.

  Which statement correctly lists the minimum steps required to perform the conversion?

  A. 1, 3, 4, 6, 8

  B. 2, 3, 5, 7

  C. 2, 5, 6, 7

  D. 1, 4, 6, 8

  E. 1, 4, 8

  F. 2, 5, 7

  Correct Answer: B

  Section: (none)

• Question 25:

  A Java application will be deployed, and you must configure a RAC database to support highly available connections. The application will use the Universal Connection Pool (UCP), and Fast Connection Failover (FCF) must be enabled. Which two statements are true? (Choose two.)

  A. The application may use the JDBC thin driver.

  B. The ons.jar file must be present in the CLASSPATH.

  C. The ONS daemon must be started on the middle tier running the Java application.

  D. You must configure TAF, either on the client or for the service.

  E. The ONS daemon must be started on the middle tier and client machines to enable FCF.

  Correct Answer: AE

  Section: (none)

• Question 26:

  Examine this command:

  SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;

  Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

  A. It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container.

  B. The source PDB must use a global temporary tablespace.

  C. The source PDB must be in READ ONLY mode on all CDB instances.

  D. Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.

  E. All running CDB instances must be open in restricted mode.

  F. The source PDB must be closed on the CDB instance from where the command is executed.

  Correct Answer: DEF

  Section: (none)

• Question 27:

  Which two statements are true about resource profiles for administrator-managed RAC database services? (Choose two.)

  A. It is automatically created when a service is created using SRVCTL ADD SERVICE.

  B. It contains a list of server pools on which the instances hosting the service can run.

  C. It contains a node list and instance-to-node mapping information for the service.

  D. It specifies the instance to which the service should fail over, if the preferred instance shuts down or fails.

  E. It is automatically created when a service is created using DBMS_SERVICE.CREATE_SERVICE.

  Correct Answer: BD

  Section: (none)

• Question 28:

  Examine this command and output:

  

  Examine this list of commands:

  1.

  srvct1 convert db -db ron -dbtype rac -node o16n1

  2.

  srvct1 convert db -db ron -dbtype raconenode -node 016n1

  3.

  srvct1 add instance -db ron -instance ron_1 -node 016n1

  4.

  srvct1 add instance -db ron -in5tance ron_2 -node 016n2

  5.

  srvct1 start instance -db ron -instance ron_1

  6.

  srvct1 start instance -db ron -instance ron_1

  Currently, there is an instance of database ron running on o16n1.

  You want to convert ron to a RAC database and make all instances available.

  Identify the commands required, in the correct order, to accomplish this.

  A. 1 3, 4, 5 and 6

  B. 2, 3, 4,5 and 6

  C. 1, 4, 5 and 6

  D. 2, 4, 5 and 6

  E. 1,4 and 6

  F. 2,4 and 6

  Correct Answer: A

  Section: (none)

• Question 29:

  Which two actions can restrict the number of instances used for parallel execution of a SQL statement? (Choose two.)

  A. setting the PARALLEL_DEGREE_POLICY to LIMITED

  B. setting the PARALLEL_FORGE_LOCAL to TRUE

  C. setting the PARALLEL_SERVERS_TARGET value equal to that of PARALLEL_MAX_SERVERS

  D. using a database service to limit the number of instances that participate in parallel execution

  E. creating a UNIFORM service for a policy-managed RAC database

  Correct Answer: AD

  Section: (none)

  Reference: https://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel002.htm

• Question 30:

  You are administering an ORACLE RAC database with multiple instances. Examine this command executed from the PROD1 instance which succeeds: CREATE SPFILE FROM MEMORY;

  Which statement is true?

  A. An SPFILE is created and contains parameter settings only for PROD1.

  B. An SPFILE is created and contains parameter settings for all instances.

  C. An SPFILE is created for each instance containing instance-specific parameter settings only.

  D. An SPFILE is created for each instance and contains parameter settings for all instances.

  Correct Answer: C

  Section: (none)

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28286/ statements_6016.htm#SQLRF01315