Oracle Oracle Certifications 1Z0-068 Questions & Answers

• Question 91:

  Your flex cluster has these attributes:

  1. Hub nodes host01 and host02

  2. Leaf nodes host03 and host04

  3. Full Featured GNS is configured and running.

  You attempt to run this command to add two more nodes to the cluster:

  $ ./addnode.sh 璼ilent "CLUSTER_NEW_NODES={host05,host06}" "CLUSTER_NEW_NODE_ROLES={hub,leaf}"

  What is the result and the reason for this result?

  A. It fails because no VIP was specified for the hub node host05.

  B. It fails because hub and leaf nodes may not be added by the same execution of addNode.sh.

  C. It fails because GNS doesn't assign VIPs for leaf nodes and no VIP was specified in the command.

  D. It succeeds because no VIP specification is required for leaf nodes and none need to be specified for hub nodes when using full featured GNS.

  Correct Answer: A

  Section: (none)

  Hub Nodes always have VIPs.

  Incorrect Answers:

  C: Hub Nodes always have VIPs but Leaf Nodes may not.

  B: Use the CLUSTER_NEW_NODE_ROLES parameter to indicate, in an Oracle Flex Cluster, whether the node you are adding is a Hub Node or a Leaf Node.

  You can add multiple nodes, as follows:

  $ addnode.sh -silent -noCopy ORACLE_HOME=Grid_home "CLUSTER_NEW_NODES= {node2,node3,node4}"

  "CLUSTER_NEW_VIRTUAL_HOSTNAMES={node2-vip,node3-vip,}"

  "CLUSTER_NEW_NODE_ROLES={HUB,HUB,LEAF}"

  In the preceding syntax example, Node 4 is designated as a Leaf Node and does not require that a VIP be included.

  References: https://docs.oracle.com/database/121/CWADD/clonecluster.htm#CWADD92139

• Question 92:

  Which two actions are performed by installing the Oracle 12c Preinstall RPM on Oracle Linux?

  A. It creates the grid user if not already defined.

  B. It modifies the /etc/sysctl.conf Linux file.

  C. It installs kernel modules required for the ASM Cluster File System (ACFS).

  D. It installs the OpenSSH client package.

  E. It creates the oinstall group if not already defined.

  Correct Answer: BE

  Section: (none)

  When installed, the Oracle Preinstallation RPM does the following:

  As needed, sets sysctl.conf settings, system startup parameters, and driver parameters to values

  based on recommendations from the Oracle Preinstallation RPM program Creates an oracle user, and creates the oraInventory (oinstall) and OSDBA (dba) groups for that user

  Automatically downloads and installs any additional RPM packages needed for installing Oracle Grid

  Infrastructure and Oracle Database, and resolves any dependencies Sets hard and soft resource limits

  Sets other recommended parameters, depending on your kernel version

  Note: The Oracle RPMs for your Oracle Linux distributions and Oracle RDBMS releases automatically install any additional packages needed for installing Oracle Grid Infrastructure and Oracle Database, and configure your server operating system automatically, including setting kernel parameters and other basic operating system requirements for installation.

  References: https://docs.oracle.com/database/121/LADBI/pre_install.htm#LADBI7493

• Question 93:

  Which three statements are true about the administration and use of policy sets in Oracle 12c Clusterware?

  A. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.

  B. Servers in a server pool outside the control of policy set are never affected by policy changes, when user-defined policy management is used.

  C. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.

  D. A server pool can have the same attributes defined for different policies in the policy set, when user- defined policy management is used.

  E. A server pool can have different attributes defined for different policies in the policy set, when user- defined policy management is used.

  Correct Answer: ACE

  Section: (none)

  A: A cluster configuration policy set is a document that defines the names of all server pools configured for the cluster and definitions for all policies.

  C: If you create policies with Oracle Database Quality of Service Management (Oracle Database QoS Management), then you categorize servers by setting server pool directive overrides, and CRSCTL commands using the policy and policyset nouns are disabled.

  Note: Oracle Database 12c has introduced the policy sets, a feature that allows preparing in advance all the different workload scenarios and activating them with a single command. The easiest way to create policy sets is dumping the current configuration into a file, edit it, and reload it into the cluster.

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

• Question 94:

  Which statement is true about using OPatch to patch Oracle Grid Infrastructure 12c?

  A. All grid infrastructure patches may be applied in a rolling fashion with Opatch.

  B. Opatch can patch all cluster nodes simultaneously without stopping the clusterware on all nodes.

  C. Opatch can patch all cluster nodes simultaneously only for nonrolling patches.

  D. Applying patches with Opatch must be done in an out-of-place fashion.

  Correct Answer: A

  Section: (none)

  As with standard upgrades to Oracle Grid Infrastructure, at any given point in time for normal operation of the cluster, all the nodes in the cluster must have the same software release and patch level. Because one-off patches can be applied

  as rolling upgrades, all possible patch levels on a particular software release are compatible with each other.

  Note: Starting with Oracle Grid Infrastructure 12c Release 1 (12.1), a new cluster state called "Rolling Patch" is available. This mode is similar to the existing "Rolling Upgrade" mode in terms of the Oracle ASM operations allowed in this

  quiesce state.

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

• Question 95:

  Examine this output: ASMCMD> volinfo ?G ACFS

  Correct Answer: C

  Section: (none)

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

  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

  Correct Answer: C

  Section: (none)

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

• Question 97:

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

  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)

  Oracle Clusterware manages applications when they are registered as resources with Oracle Clusterware. Oracle Clusterware has access to application-specific primitives that have the ability to start, stop, and monitor a specific resource.

  Oracle Clusterware runs all resource-specific commands through an entity called an agent.

  Note: When initializing the agent framework, if any of the mandatory entry points are not provided, then the agent framework invokes a script pointed to by the ACTION_SCRIPT resource attribute. References: https://docs.oracle.com/

  database/121/CWADD/crschp.htm#CWADD92082

• Question 98:

  Which two statements are true about resources defined by an administrator and registered with Oracle 12c Clusterware for high availability?

  A. A policy-managed resource can be started manually using crsctl.

  B. A policy-managed resource can be started manually using srvctl.

  C. Resource dependencies are automatically set when using a policy-managed resource.

  D. An administrator-managed resource can be started manually using crsctl.

  E. An administrator-managed resource can be started manually using srvctl.

  F. The action script is automatically set when using a policy-managed resource.

  Correct Answer: AE

  Section: (none)

  A: With policy-based management, administrators specify the server pool (excluding the Generic and Free pools) in which the servers run. For example, a database administrator uses SRVCTL to create a server pool for servers hosting a database or database service. A clusterware administrator uses CRSCTL to create server pools for non-database use, such as creating a server pool for servers hosting an application.

  E: Administrator-managed resources refer to databases. You must use SRVCTL to create server pools that host Oracle databases. You must use CRSCTL to create server pools that host non-database resources such as middle tiers and applications.

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

• Question 99:

  A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections.

  Broken connections must be re-established as quickly as possible.

  Which feature will support this requirement?

  A. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)

  B. Transparent Application Failover (TAF)

  C. Transparent Application Failover (TAF) using Fast Application Notification (FAN)

  D. Fast Connection Failover (FCF)

  Correct Answer: C

  Section: (none)

  The Fast Connection Failover (FCF) feature is an Oracle RAC/Fast Application Notification (FAN) client implemented through the connection pool. The feature requires the use of an Oracle JDBC driver and an Oracle RAC database.

  References: https://docs.oracle.com/cd/B28359_01/java.111/e10788/rac.htm

• Question 100:

  Which three statements are true concerning policy-based cluster management in Oracle 12c Clusterware?

  A. Server Pools must be managed with the crsctl utility for servers hosting an application or other administrator-defined high-availability resource.

  B. All servers in a new cluster installation belong to the generic server pool.

  C. The server pool contains servers that host administrator-defined high availability resources.

  D. Server pools must be managed with the srvctl utility for servers hosting a database.

  E. All servers in a new cluster installation belong to the free server pool.

  Correct Answer: CDE

  Section: (none)

  C: Server pools divide the cluster into logical groups of servers hosting both singleton and uniform applications. The application can be a database service or a non-database application.

  D: You manage server pools that contain Oracle RAC databases with the Server Control (SRVCTL) utility.

  E: When Oracle Clusterware is installed, two internal server pools are created automatically: Generic and Free. All servers in a new installation are assigned to the Free server pool, initially

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