Oracle 1Z0-068 Online Practice Questions and Exam Preparation

Oracle 1Z0-068 Online Questions & Answers

• Question 1:

  Examine this command executed on the first node of a four-node cluster: $ /0Patch/opatch apply 18031528 What does this command do?

  A. It applies a patch to one ORACLE_HOME only on the first cluster node.
  B. It applies a patch to all database ORACLE_HOMEs with the same release only on the first cluster node.
  C. It applies a patch to one ORACLE_HOME on all cluster nodes.
  D. It applies a patch to all database ORACLE_HOMEs with the same release on all cluster nodes.
  E. It applies a patch to all database ORACLE_HOMEs with the same release on the first cluster node.
  B. It applies a patch to all database ORACLE_HOMEs with the same release only on the first cluster node.

• Question 2:

  Examine this output: ASMCMD> volinfo ?G ACFS A. It succeeds
  B. It fails because the file system must be unmounted before resizing.
  C. It fails because resizing a volume containing an ACFS file system must be performed using ACFSUTIL.
  D. It succeeds but the file system is automatically unmounted.
  E. It fails because the

  C. It fails because resizing a volume containing an ACFS file system must be performed using ACFSUTIL.

  ---

  If there is an Oracle ACFS file system on the volume, then you cannot resize the volume with the volresize command. You must use the acfsutil size command, which also resizes the volume and file system. References: https://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_util007.htm#OSTMG94769

• Question 3:

  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. 1, 3, 2, 5 and 8
  B. 3, 2, 5 and 8
  C. 1, 2, 3, 5 and 8
  D. 3, 2, 6 and 8
  E. 3, 2, 5, 2 and 8
  C. 1, 2, 3, 5 and 8

  ---

  Reference: https://docs.oracle.com/cd/B19306_01/rac.102/b28759/softpatch.htm#TDPRC918

• Question 4:

  Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC?

  A. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes.
  B. Grid infrastructure must be installed on all cluster nodes where the Database software will be installed.
  C. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database Software will be installed.
  D. Grid infrastructure must be installed on all cluster nodes.
  E. The Clusterware stack must be up on all cluster nodes.
  A. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes.
  D. Grid infrastructure must be installed on all cluster nodes.

  ---

  A: You must enable SSH User Equivalency on Cluster Nodes.

  References: https://docs.oracle.com/database/121/CWLIN/manpreins.htm#CWLIN407

• Question 5:

  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.
  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.

  ---

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

• Question 6:

  PROD1, PROD2 and PROD3 are three instances that have multitenant container database PROD open.

  PROD contains multiple PDBs.

  Examine these successful commands:

  $ srvctl add service 璬b PROD 璸db PRDPDB1 璼ervice SRVPDB1 $ srvctl start service璬b PROD 璼ervice SRVPDB1

  Which statement is true about the srvctl start service command?

  A. It opens the PRDPDB1 PDB if not already opened.
  B. It can open the PRDPDB1 PDB only if it is policy managed.
  C. It can open the PRDPDB1 PDB automatically.
  D. It can open the PRDPDB1 PDB only if it is manually managed.
  B. It can open the PRDPDB1 PDB only if it is policy managed.

• Question 7:

  You administer a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs: PDB_1 and PDB_2.

  Examine these commands executed on host01: $ srvctl add service 璬b CDB1 璸db PDB_1 璼erverpool prod_pool 璫ardinality singleton $ srvctl start service璬b CDB1 璼ervice CRM $ srvctl stop service 璬b CDB1 璼ervice CRM

  Which three statements are true?

  A. CRM is only available for new logins on the CDB1 instance on host01.
  B. CRM is available for new logins on one CDB1 instance.
  C. The srvctl start service command automatically opens PDB_1 if not already opened.
  D. The srvctl stop service command does not close PDB_1 on any instance of CDB1.
  E. The CRM service is not available for new logins on any instance of CDB1.
  C. The srvctl start service command automatically opens PDB_1 if not already opened.
  D. The srvctl stop service command does not close PDB_1 on any instance of CDB1.
  E. The CRM service is not available for new logins on any instance of CDB1.

• Question 8:

  Which three statements are true regarding Flex ASM on a four-node cluster consisting of three-hub nodes and a leaf node?

  A. An ASM instance and database instances can coexist on the same hub node.
  B. A database instance on a hub node can be a client of an ASM instance running on any leaf node.
  C. A database instance on a hub node can be a client of an ASM instance running on any hub node.
  D. A database instance on a leaf node can be a client of an ASM instance running on any hub node.
  E. A database instance on a hub node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
  F. ASM Cluster File System (ASFS) can only be deployed on hub nodes.
  A. An ASM instance and database instances can coexist on the same hub node.
  C. A database instance on a hub node can be a client of an ASM instance running on any hub node.
  F. ASM Cluster File System (ASFS) can only be deployed on hub nodes.

  ---

  Architecturally Oracle Flex Cluster comprises of a Hub and Leaf architecture where in only the Hub nodes will only have direct access to Oracle Cluster Registry (OCR) and Voting Disk (VD). However application can access the database via

  Leaf nodes without ASM instance NOT running on Leaf nodes. The connection to the database is through Hub making it transparent for the application.

  Note:

  Hub Nodes are connected among them via private network and have direct access to the shared storage just like previous versions. These nodes are the ones that access the Oracle Cluster Registry (OCR) and Voting Disk (VD) directly.

  Leaf Nodes are lighter and are not connected among them, neither accesses the shared storage like the Hub Nodes. Each Leaf Node communicates with the Hub Node that is attached to, and it is connected to the cluster via the Hub Node

  that is linked to.

  References: http://www.oracle.com/technetwork/articles/database/flexasm-flexcluster-benefits-odb12c- 2177371.html

• Question 9:

  You administer a three-instance, policy-managed, multitenant RAC database CDB1 with three PDBs:

  , PDB_2, and PDB_3.

  PDB_1

  You want to drop PDB_3.

  Which two statements are true? (Choose two.)

  A. PDB_3 must be closed on all CDB1 instances.
  B. Manually created services for PDB_3 are not removed automatically from the OCR when dropping PDB_3.
  C. CDB1 must be open in restricted mode on all cluster nodes.
  D. PDB_3 must be open READ ONLY in all CDB1 instances.
  E. Manually created services for PDB_3 are removed automatically from the OCR when dropping PDB_3.
  B. Manually created services for PDB_3 are not removed automatically from the OCR when dropping PDB_3.
  E. Manually created services for PDB_3 are removed automatically from the OCR when dropping PDB_3.

• Question 10:

  Which two utilities support the "what-if" command evaluation?

  A. asmcmd
  B. ocrconfig
  C. oifcfg
  D. crsctl
  E. srvctl
  D. crsctl
  E. srvctl

  ---

  The What-If Command Evaluation feature is designed to evaluate the impact of a command executed against the cluster prior to its execution. There are two levels of the What-If Command Evaluation: a view for cluster administrators

  

  a view for database administrators.

  

  The difference between the two ?other than the fact that they are provided by either CRSCTL (for the cluster administrator) or SRVCTL (for the database administrator) ?is their information detail. References: http://www.oracle.com/technetwork/products/clustering/rac-wp-12c-1896129.pdf