Oracle 1Z0-068 Online Practice Questions and Exam Preparation

Oracle 1Z0-068 Online Questions & Answers

• Question 1:

  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.
  A. A block is busy in the local cache.
  B. A block is busy in the remote cache.

  ---

  explanation:

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

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

• Question 3:

  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.
  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.
  D. The concurrency values are not shown because sales in not a RAC One Node database.

• Question 4:

  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.
  B. Clients using EZConnect can benefit from connect time load balancing because the tnsnames entry refers to a SCAN listener.
  D. A client connection request is received by a SCAN listener that creates the connection to the least- loaded database instance.

• Question 5:

  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
  C. an application resource
  E. a script agent

• 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.
  B. Hug node eviction results in the reboot 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.
  G. Cluster Resources on a hub node that is evicted from a Flex Cluster are always relocated to another hub node in the cluster.

• Question 7:

  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
  B. a version of Oracle database server used in Real Application Cluster (RAC) databases
  D. the GPnP software
  F. a version of Automatic Storage Management (ASM) used for the cluster

• Question 8:

  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
  A. a Grid Management Repository database
  C. a network interface for private interconnect only

• Question 9:

  Which three commands can be used to verify the integrity of Oracle Clusterware 12c OCR and OLR files? (Choose three.)

  A. ocrcheck
  B. ocrcheck -config -local
  C. ocrcheck -local
  D. ocrcheck -config
  E. cluvfy comp ocr -n all -verbose
  A. ocrcheck
  B. ocrcheck -config -local
  E. cluvfy comp ocr -n all -verbose

• Question 10:

  Which three are characteristics of leaf nodes in an Oracle Clusterware 12c Flex Cluster? (Choose three.)

  A. They can be on a different subnet to the hub nodes.
  B. Grid Naming Service (GNS) must exist on one of the leaf nodes.
  C. They discover hub nodes automatically at startup.
  D. They require direct access to shared storage.
  E. They may discover hub nodes without having the DNS delegation configured by network.
  F. Oracle database 12c RAC instances may not run on leaf nodes.
  D. They require direct access to shared storage.
  E. They may discover hub nodes without having the DNS delegation configured by network.
  F. Oracle database 12c RAC instances may not run on leaf nodes.