Oracle Oracle Database 1Z0-068 Questions & Answers

• Question 1:

  You created a RAC database with DBCA and decide to verify it.

  The server pool large_db has four servers.

  Examine the output shown:

  

  Which two statements are true based on this output? (Choose two.)

  A. The sales database resource will be started and the database instances will be started automatically when restarting the clusterware stack after normal shutdown of the sales database.

  B. The sales database resource will be restored to its previous running condition when restarting the clusterware stack after normal shutdown of the sales database.

  C. The sales database resource will be restarted automatically after an instance failure.

  D. The concurrency values are not shown because sales in not a RAC One Node database.

  E. The concurrency values are not shown because sales has only one of its four instances running.

  Correct Answer: BD

  Section: (none)

• Question 2:

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

  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 where the Database software will be installed.

  F. The Clusterware stack must be up on all cluster nodes.

  Correct Answer: AD

  Section: (none)

• Question 3:

  Identify two reasons for the gc current block busy wait event. (Choose two.)

  A. A block is busy in the local cache.

  B. A block is busy in the remote cache.

  C. The Cluster Interconnect is congested.

  D. Either the local or remote CPUs have too large a run queue.

  Correct Answer: AB

  Section: (none)

  Reference: https://docs.oracle.com/cd/B28359_01/rac.111/b28254/monitor.htm#RACAD976

• Question 4:

  You are installing Oracle Grid Infrastructure 12c and configuring a Flex Cluster?

  Which two elements are required to support this configuration? (Choose two.)

  A. a Grid Management Repository database

  B. a network interface for ASM and private interconnect traffic

  C. a network interface for private interconnect only

  D. a network interface for the public network

  E. a Grid Management Cluster Health Management (CHM) application server

  Correct Answer: AC

  Section: (none)

• Question 5:

  Which three are among the minimum components in a software image that is part of a Grid Plug and Play (GPnP) profile in Oracle Clusterware? (Choose three.)

  A. an operating system version

  B. a version of Oracle database server used in Real Application Cluster (RAC) databases

  C. software required to configure nodes at startup

  D. the GPnP software

  E. a file system version used for the software to be installed

  F. a version of Automatic Storage Management (ASM) used for the cluster

  Correct Answer: BDF

  Section: (none)

• Question 6:

  Which three statements are true concerning the behavior of an Oracle Clusterware 12c Flex Cluster in response to hub or leaf node failures? (Choose three.)

  A. Leaf nodes evicted from a Flex Cluster always require a reboot.

  B. Hug node eviction results in the reboot of all leaf nodes that were connected to the evicted hub node.

  C. Hub nodes evicted from a Flex Cluster always require a reboot.

  D. Hub node eviction results in the eviction of all leaf nodes that were connected to the evicted hub node.

  E. Cluster Resources on a leaf node that is evicted from a Flex Cluster are relocated, if possible, to another leaf node that is connected to same hub node to which the failed leaf node was connected.

  F. Cluster Resources on a hub node that is evicted from a Flex Cluster are always relocated to a leaf node that was connected to the evicted hub node.

  G. Cluster Resources on a hub node that is evicted from a Flex Cluster are always relocated to another hub node in the cluster.

  Correct Answer: BEG

  Section: (none)

• Question 7:

  Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 12c Clusterware? (Choose two.)

  A. A Server Pool

  B. an application VIP

  C. an application resource

  D. a resource dependency definition

  E. a script agent

  Correct Answer: CE

  Section: (none)

• Question 8:

  Examine this tnsnames entry from a RAC configuration using a SCAN listener:

  HR=(DESCRIPTION=

  (LOAD_BALANCE =on)

  (ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan)(FORT=1521)) (CONNECT_DATA=(SERVICE_NAME=HRSRV)))

  Which two statements are true about clients using this entry to connect? (Choose two.)

  A. The host name in the tnsnames entry must be changed if nodes are added or removed from the Cluster.

  B. Clients using EZConnect can benefit from connect time load balancing because the tnsnames entry refers to a SCAN listener.

  C. Client connection requests are automatically balanced across all IP addresses defined for the SCAN.

  D. A client connection request is received by a SCAN listener that creates the connection to the least- loaded database instance.

  E. Client connection requests are automatically failed over to another SCAN listener if the chosen SCAN listener is not available.

  Correct Answer: BD

  Section: (none)

• Question 9:

  Which three statements are true about diagnostic reporting for the OCR and OLR flies? (Choose three.)

  A. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.

  B. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.

  C. The OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.

  D. The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes.

  E. The CLUVFY utility can check the integrity of the OCR but not the OLR

  Correct Answer: ACE

  Section: (none)

• Question 10:

  Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 12c? (Choose two.)

  A. The Installer permits the creation of a disk group for use by the voting disks and OCR file.

  B. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.

  C. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.

  D. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.

  E. ASM disk groups used for voting files and OCR files require a quorum failgroup.

  Correct Answer: DE

  Section: (none)