1z1-068 by Oracle Valid Free Exam Practice Test

Question 1

Which two statements are true about node listeners in a Grid Infrastructure Cluster using Flex ASM?

A. They listen only for the ASM instance on the same node. B. They run from the Grid Infrastructure home by default. C. They listen on behalf on any ASM instance and all database instances on the same node. D. There only can be one node listener per node. E. They listen only for database instances on the same node.

Correct Answer: B,C

Question 2

Which statement is true concerning the installation of an Oracle Grid Infrastructure 12c patchset and its status during the installation?

A. They can be applied in-place. B. When performing rolling patches, crsctl query crs softwareversion always displays the lowest version of the software running anywhere in the cluster C. Some grid infrastructure patchsets may not be installed in a rolling fashion. D. When performing rolling patches, the VIPs for the node being patched are relocated to another node.

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

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_SERVERS_TARGET value equal to that of PARALLEL_MAX_SERVERS C. creating a UNIFORM service for a policy-managed RAC database D. using a database service to limit the number of instances that participate in parallel execution E. setting the PARALLEL_FORGE_LOCAL to TRUE

Correct Answer: A,D

Question 4

You are developing a user callout procedure to send an email to the helpdesk whenever a RAC database instance fails to restart after node failure.
Examine these tasks (see exhibit):

Identify the minimum steps required, in the correct sequence, to implement this.

A. 2, 4, 7, 8 B. 2, 4, 7 C. 1, 3, 7 D. 1, 4, 7, 8 E. 2, 5, 8 F. 1, 4, 6

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 5

Which three statements are true about Oracle 12c multitenant RAC databases created using the Database Configuration Assistant (DBCA) on a cluster from a RAC database home? (Choose three.)

A. They have a unique service name created for each pluggable database (PDB) automatically registered as a cluster service resource. B. They can have multiple pluggable databases (PDB) when the container database (CDB) is created. C. They have their pluggable databases (PDBs) opened in each container database (CDB) instance automatically after CDB creation. D. They can be administrator managed. E. They are automatically configured to use Enterprise Manager Express. F. They can be policy managed.

Correct Answer: B,D,F

Question 6

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

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

Correct Answer: A

Question 7

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

A. Resource dependencies are automatically set when using a policy-managed resource. B. A policy-managed resource can be started manually using srvctl. C. An administrator-managed resource can be started manually using crsctl. D. An administrator-managed resource can be started manually using srvctl. E. A policy-managed resource can be started manually using crsctl. F. The action script is automatically set when using a policy-managed resource.

Correct Answer: D,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 8

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. 3, 2, 5 and 8 B. 1, 2, 3, 5 and 8 C. 3, 2, 5, 2 and 8 D. 1, 3, 2, 5 and 8 E. 3, 2, 6 and 8

Correct Answer: D

Question 9

Which three statements are true about diagnostic reporting for the OCR and OLR flies? (Choose three.)

A. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes. B. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes. C. The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes. D. The OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes. E. The CLUVFY utility can check the integrity of the OCR but not the OLR

Correct Answer: B,D,E

Question 10

Which two statements are true about Quality of Service Management?

A. It can improve the performance of PL/SQL. B. It can improve the performance of SQL statements. C. It can enable a more efficient sharing of hardware resources. D. It can reduce the load on the system caused by Oracle background processes. E. It can improve system stability as the workload changes.

Correct Answer: C,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 11

Examine the output of the asmcmd and srvct1 commands:

You execute this command:
$ srvctl modify asm -count 2
All databases on the cluster are running from Oracle 12c homes.
Which statement is true about the outcome of this command?

A. The command fails because the instance count cannot be reduced to less than the minimum value of 3. B. The command fails because one ASM instance must be shut down manually before executing the command. C. One ASM instance is shut down and the instance count is reduced by one. D. ASM instances continue running on all three nodes until all database instances connected to one of the ASM instances shut down.

Correct Answer: C

Question 12

Examine the output of this command:
ASMCMD> volinfo -G ACFS -a
Diskgroup Name: ACFS
Volume Name: VOL1
Volume Device: /dev/asm/vol1-280
State: ENABLED
Size (MB): 2048
Resize Unit (MB): 32
Redundancy: MIRROR
Stripe Columns: 4
Stripe Width (K): 128
Usage: ACFS
Mountpath: /u01/app/grid/acfsmount
The ACFS disk group is a normal redundancy disk group with 5 GB of free space.
To increase the size of the ACFS file system, you execute this command as the root user:
$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command?

A. It resizes the filesystem mounted on /u01/app/grid/acfsmount. B. It succeeds but leaves the filesystem unmounted. C. It fails to resize the filesystem because it must be unmounted before resizing. D. It fails to resize VOL1 because it must be executed as a user belonging to the SYSASM group. E. It resizes VOL1.

Correct Answer: B,E

Question 13

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

A. A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used. B. A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used. C. Servers in a server pool outside the control of policy set are never affected by policy changes, when user-defined policy management is used. D. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used. E. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.

Correct Answer: B,D,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Oracle Database 12c: RAC and Grid Infrastructure Administrator - 1z1-068 Exam Practice Test