Oracle Oracle Certifications 1Z0-068 Questions & Answers

• Question 81:

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

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

  B. Run the rootcrs.pl ?delete 璮orce command as root on host01, or on either host02 or host03.

  C. Run the rootcrs.pl ?delete 璮orce command as root on host04.

  D. Run the crsctl delete node -n host04 command as root on host04.

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

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

  Correct Answer: AF

  Section: (none)

  To delete a node from a cluster:

  1. Ensure that Grid_home correctly specifies the full directory path for the Oracle Clusterware home on each node, where Grid_home is the location of the installed Oracle Clusterware software.

  2. (A) Run the following command as either root or the user that installed Oracle Clusterware to determine whether the node you want to delete is active and whether it is pinned:

  $ olsnodes -s

• Question 82:

  Which two are characteristics of any node that is part of a Grid Plug and Play (GPnP) Domain in Oracle Clusterware?

  A. It has at least two nonroutable interfaces inside the GPnP domain for the private interconnect.

  B. It has at least two routable interfaces outside the GPnP domain for the public interface.

  C. It has at least one routable interface inside the GPnP domain for the private interconnect.

  D. It has at least one routable interface outside the GPnP domain for the public interface.

  E. It has a unique identifier that is unique outside the GPnP domain.

  F. It has a unique identifier that is unique inside the GPnP domain.

  Correct Answer: DF

  Section: (none)

  Each node participating in a GPnP domain has the following characteristics:

  At least one routable interface with connectivity outside of the GPnP domain for the public interface

  *A unique identifier that is unique within the GPnP domain

  A personality affected by the GPnP profile, physical characteristics, and software image of the node

  References: https://docs.oracle.com/cd/E11882_01/server.112/e41360/chapter1.htm#NEWFT107

• Question 83:

  Which three statements are true concerning activation of a user-defined policy in Oracle 12c Clusterware?

  A. When a policy is first created, it is initially active.

  B. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.

  C. An administrator-defined policy may be activated using the srvctl utility.

  D. When a policy is activated, resources cannot be automatically started to comply with the policy definition.

  E. When a policy is first created, it is initially inactive.

  F. When a policy is activated, resources can be automatically stopped to comply with the policy definition.

  Correct Answer: BCE

  Section: (none)

  BE: You can activate policies when necessary, prompting Oracle Clusterware to reconfigure a server pool according to each policy's configuration.

  C: The following command activates the DayTime policy:

  $ crsctl modify policyset -attr "LAST_ACTIVATED_POLICY=DayTime"

  References: https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92594

• Question 84:

  Which three events occur when a hub node fails in an Oracle Clusterware 12c Flex Cluster?

  A. The hub node is evicted from the cluster

  B. Leaf nodes connected to the failing hub node are reconnected to a surviving hub node without service disruption.

  C. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving hub nodes.

  D. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving leaf nodes.

  E. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes.

  F. Cluster resources running on the failed hub node are relocated to one or more surviving leaf nodes.

  G. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes or leaf nodes, or both.

  Correct Answer: ABE

  Section: (none)

  Incorrect Answers:

  F, G: Leaf Nodes are different from standard Oracle Grid Infrastructure nodes, in that they do not require direct access to shared storage, but instead request data through Hub Nodes. Hub Nodes can run in an Oracle Flex Cluster

  configuration without having any Leaf Nodes as cluster member nodes, but Leaf Nodes must be members of a cluster that includes at least one Hub Node.

  Reference: https://docs.oracle.com/database/121/CWADD/bigcluster.htm#CWADD92409

• Question 85:

  Which two Operating System users and groups must be created on each node before installing Oracle Grid Infrastructure 12c?

  A. an O/S user to own the Clusterware installation and a different O/S user to own the Automatic Storage Management (ASM) installation

  B. an O/S group to own the software inventory

  C. an O/S user to own the Oracle Database installation

  D. an O/S group called dba

  E. a group to own the ASMLIB-provisioned storage

  F. a group to own Automatic-Storage Management (ASM) Filter Driver-provisioned storage

  Correct Answer: BD

  Section: (none)

  B: Creating the Oracle Inventory Group If an Oracle Inventory Does Not Exist If the oraInst.loc file does not exist, then create the Oracle Inventory group by entering a command similar to the following: # /usr/sbin/groupadd -g 54321 oinstall

  The preceding command creates the oraInventory group oinstall, with the group ID number 54321. Members of the oraInventory group are granted privileges to write to the Oracle central inventory (oraInventory), and other system privileges for Oracle installation owner users.

  D: Oracle recommends that you create one software owner to own each Oracle software product (typically, oracle, for the database software owner user, and grid for Oracle Grid Infrastructure).

  Incorrect Answers:

  A: During an Oracle Grid Infrastructure installation, both Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM) are installed. You no longer can have separate Oracle Clusterware installation owners and Oracle ASM installation owners.

  References: https://docs.oracle.com/database/121/CWLIN/usrgrps.htm#CWLIN179

• Question 86:

  Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 12c?

  A. The ORACLE_HOME environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.

  B. The upgrade must be done in-place.

  C. The upgrade must be done out of place.

  D. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.

  E. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.

  F. The ORACLE_SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.

  G. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.

  Correct Answer: ACEG

  Section: (none)

  References: https://docs.oracle.com/database/121/CWLIN/procstop.htm#CWLIN422

• Question 87:

  Which three statements are true about displaying the location of voting files, OCR files, or OLR files in Oracle Clusterware 12c on a UNIX system?

  A. Use cat /etc/oracle/ocr.loc to view the location of the OCR if stored in ASM.

  B. Use ocrcheck command to view the location of the OCR only if stored in a file system.

  C. Use crsctl querry votedisk to view the location of voting files if stored in ASM.

  D. Use the ls command in the asmcmd utility to view the location of voting files if stored in ASM.

  E. Use crsctl query votedisk to view the location of voting files if stored in a file system.

  F. Use cat /etc/oracle/olr.loc to view the location of the OCR and OLR if stored on a file system.

  Correct Answer: BEF

  Section: (none)

  B: The OCRCHECK utility displays the version of the OCR's block format, total space available and used space, OCRID, and the OCR locations that you have configured

  Use the ocrconfig -add command to add an OCR location to a shared file system or Oracle Automatic Storage Management (Oracle ASM) disk group.

  Note: The example shows using the ocrcheck -config -details command to obtain the location of OCR in an Oracle ASM disk group.

  Using OCRCHECK to Obtain OCR Information: $ ocrcheck -config -details

  Oracle Cluster Registry configuration is :

  Device/File Name : +ocrvd11/mjk_1/OCRFILE/registry.255.842574113 Device/File Name : +ocrdv2/mjk_1/OCRFILE/registry.255.842574125

  E: To determine the current voting disk by issuing the following command:

  crsctl query votedisk css

  F: The olr.loc file consists of the OLR config file location and the crs_home location.

  $ cat olr.loc

  olrconfig_loc=/u01/app/oracle/grid/11.2.0/cdata/.olr crs_home=/u01/app/oracle/grid/11.2.0

  So, by default the location is olrconfig_loc =/cdata/.olr.

  References:

  https://docs.oracle.com/database/121/CWADD/ocrsyntax.htm#CWADD92028 https://gjilevski.com/2009/09/23/what-is-a-voting-disk/

• Question 88:

  Which two statements are true regarding the configuration of ASM disk groups when installing Oracle Grid Infrastructure 12c?

  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: AB

  Section: (none)

  You can store Oracle Cluster Registry (OCR) and voting files in Oracle ASM disk groups.

  Incorrect Answers:

  D: If you install Oracle Database or Oracle RAC after you install Oracle Grid Infrastructure, then you can either use the same disk group for database files, OCR, and voting files, or you can use different disk groups. If you create multiple disk

  groups before installing Oracle RAC or before creating a database, then you can do one of the following:

  Place the data files in the same disk group as the Oracle Clusterware files.

  Use the same Oracle ASM disk group for data files and recovery files.

  Use different disk groups for each file type.

  References: https://docs.oracle.com/database/121/CWLIN/storage.htm#CWLIN488

• Question 89:

  When installing Oracle Grid Infrastructure 12c, which three options exist for the configuration of Grid naming Service (GNS)?

  A. using Shared GNS for the leaf nodes and local GNS for the hub nodes in a Flex Cluster

  B. using Shared GNS running on another cluster

  C. using Shared GNS for the hub nodes and local GNS for the leaf nodes in a Flex Cluster

  D. creation of a new GNS for this cluster

  E. using DHCP to assign Node Virtual IP addresses for nodes in the cluster

  Correct Answer: BDE

  Section: (none)

  B: With dynamic configurations, you can configure GNS to provide name resolution for one cluster, or to advertise resolution for multiple clusters, so that a single GNS instance can perform name resolution for multiple registered clusters. This option is called shared GNS.

  D: With static configurations, no subdomain is delegated. A DNS administrator configures the GNS VIP to resolve to a name and address configured on the DNS, and a DNS administrator configures a SCAN name to resolve to three static addresses for the cluster.

  E: With automatic configurations, a DNS administrator delegates a domain on the DNS to be resolved through the GNS subdomain. Automatic configuration occurs in one of the following ways: For IPv4 addresses, Oracle Clusterware assigns unique identifiers for each cluster member node

  interface allocated for Oracle Grid Infrastructure, and generates names using these identifiers within the subdomain delegated to GNS. A DHCP server assigns addresses to these interfaces, and GNS maintains address and name associations with the IPv4 addresses leased from the IPv4 DHCP pool. For IPv6 addresses, Oracle Clusterware automatically generates addresses with autoconfig.

  References: https://docs.oracle.com/database/121/CWADD/admin.htm#CWADD838

• Question 90:

  Which three statements are true about Oracle Clusterware components, architecture, and behavior?

  A. The Cluster Ready Services Daemon (CRSD) is responsible for monitoring and maintaining the availability of cluster resources defined in the Oracle Local Repository file (OLR).

  B. All cluster nodes can write or read from the Oracle Clusterware Repository (OCR) file at the same time.

  C. The Oracle High Availability Services Daemon (OHASD) is responsible for monitoring and maintaining the availability of the Clusterware stack on a cluster node.

  D. Voting disks stored in Automatic Storage Management (ASM) can be discovered or used even if the ASM instance on a cluster node is down.

  E. The Cluster Synchronization Services Daemon (CSSD) must connect to the cluster by accessing the Oracle Clusterware Repository (OCR) file before the Oracle High Availability Services Daemon (OHASD) is started.

  F. Time synchronization in an Oracle Cluster is possible without using network Time Protocol (NTP).

  Correct Answer: CDF

  Section: (none)

  F: To activate CTSS in your cluster, you must stop and deconfigure the vendor time synchronization service on all nodes in the cluster. CTSS detects when this happens and assumes time management for the cluster.

  For example, to deconfigure NTP, you must remove or rename the ntp.conf file.

  Incorrect Answers:

  A: The CRS daemon (crsd) manages cluster resources based on the configuration information that is stored in OCR, not the OLR, for each resource.

  B: You must update OCR through supported utilities such as Oracle Enterprise Manager, the Oracle Clusterware Control Utility (CRSCTL), the Server Control Utility (SRVCTL), the OCR configuration utility (OCRCONFIG), or the Database Configuration Assistant (DBCA)

  E: Please refer to the cluster startup picture below.

  

  References: https://docs.oracle.com/cd/E11882_01/rac.112/e41959/intro.htm#CWADD90955