Free 1Z0-068 Exam Dumps

Question 11

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
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 12

Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 12c?

A. Update the PATH environment variable on each cluster node to point to the $ORACLE_HOME/OPatch directory.
B. Stage the patch on the cluster node where the OPatch utility will be executed.
C. Update the PATH environment variable on the node where will run the OPatch utility to point to the$ORACLE_HOME/OPatch directory.
D. Stage the patch on the cluster nodes.

Correct Answer:C

Question 13

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

Question 14

Which two actions can restrict the number of instances used for parallel execution of a SQL statement? (Choose two.)

A. setting the PARALLEL_DEGREE_POLICY to LIMITED
B. setting the PARALLEL_FORGE_LOCAL to TRUE
C. setting the PARALLEL_SERVERS_TARGET value equal to that of PARALLEL_MAX_SERVERS
D. using a database service to limit the number of instances that participate in parallel execution
E. creating a UNIFORM service for a policy-managed RAC database

Correct Answer:AD

Question 15

Which three resources are managed using global concurrency control in an Oracle 12c RAC multi-instance database? (Choose three.)

A. latches
B. enqueues
C. database block buffers
D. mutexes
E. cursors
F. redo log buffers

Correct Answer:ABC