1z0-068 Exam Dumps 2019 - Latest Exam Collection 1z0-068 study materials
                              O    r  a  c  l e    1 z0-068 Dumps PDF
Oracle Database 12c: RAC and Grid Infrastructure 
Administration
For More Info:
https://www.realexamdumps.com/oracle/1z0-068-practice-test.html
 
Question: 1 
   
You plan to apply a patchset to a RAC database running on a two-node cluster. 
The cluster has this configuration: 
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 
 
Answer: A     
 
Question: 2 
   
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 
 
Answer: C,E     
 
Explanation: 
 
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: 3 
   
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. 
 
Answer: A,E     
 
Explanation: 
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: 4 
   
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. 
 
Answer: A     
 
 
Explanation: 
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: 5 
   
Which three statements are true about the administration and use of policy sets in Oracle 12c 
Clusterware? (Choose three.) 
 
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. 
 
Answer: A,C,E     
 
Explanation: 
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: 6 
   
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 –silent “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. 
 
Answer: A     
 
Explanation: 
Hub Nodes always have VIPs. 
 
Question: 7 
   
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. 
 
Answer: B,E     
 
Explanation: 
When installed, the Oracle Preinstallation RPM does the following: 
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: 8 
   
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). 
 
Answer: C,D,F     
 
Explanation: 
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. 
 
Question: 9 
   
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. 
 
Answer: A,B     
 
Explanation: 
You can store Oracle Cluster Registry (OCR) and voting files in Oracle ASM disk groups. 
 
Question: 10 
   
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 
 
Answer: A,D,E     
 
Question: 11 
   
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. 
 
Answer: A,C,E     
 
Question: 12 
   
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 
 
Answer: B,D     
 
Explanation: 
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). 
 
Question: 13 
   
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. 
 
Answer: A,C,E,G     
 
Explanation: 
A: Use the following command to start the installer, where the path you provide for the flag 
ORACLE_HOME is the location of the home directory from the earlier Oracle Clusterware installation 
For example: 
$ cd /u01/app/12.1.0/grid/oui/bin 
$ ./runInstaller -nowait -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent 
CRS=true ORACLE_HOME=/u01/app/crs 
C: Oracle Clusterware and Oracle ASM upgrades are always out-of-place upgrades. You cannot perform 
an in-place upgrade of Oracle Clusterware and Oracle ASM to existing homes. 
E, G: Run the CVU manual script cluvfy.sh script to perform system checks and generate fixup scripts 
 
Question: 14 
   
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 – deconfig –force command as root on host01, or on either host02 or host03. 
C. Run the rootcrs.pl – deconfig –force command as root on host04. 
D. Run the crsctl unpin css -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. 
 
Answer: C,F     
 
Explanation: 
To delete a node from a cluster: 
References: https://docs.oracle.com/database/121/CWADD/adddelclusterware.htm#CWADD90992 
 
Question: 15 
   
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. 
 
Answer: D,F     
 
Explanation: 
Each node participating in a GPnP domain has the following characteristics: 
References: https://docs.oracle.com/cd/E11882_01/server.112/e41360/chapter1.htm#NEWFT107 
 
Question: 16 
   
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. 
 
Answer: B,C,E     
 
Explanation: 
 
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: 17 
   
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. 
 
Answer: A,B,E