1z1-068 by Oracle Actual Free Exam Questions And Answers

Question 1

Which two statements are true about initialization parameters for Clustered ASM instances?

A. The maximum value of ASM_POWER_LIMIT is 1024.

B. The ASM_DISKGROUP parameter is optional.

C. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.

D. The default value of INSTANT_TYPE is ASM.

E. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.

Discussion 0

Correct Answer: A,B Vote an answer

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

Question 2

You administer a three-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2, and PDB_3.
You want to drop PDB_3.
Which two statements are true? (Choose two.)

A. Manually created services for PDB_3 are not removed automatically from the OCR when dropping PDB_3.

B. PDB_3 must be closed on all CDB1 instances.

C. Manually created services for PDB_3 are removed automatically from the OCR when dropping PDB_3.

D. CDB1 must be open in restricted mode on all cluster nodes.

E. PDB_3 must be open READ ONLY in all CDB1 instances.

Discussion 0

Correct Answer: B,C Vote an answer

Question 3

Examine this command to create a volume in the DATA disk group:
SQL>ALTER DISKGROUP DATA ADD VOLUME vo11 SIZE 10g HIGH
STRIPE_WIDTH 1M;
STRIPE_COLUMNS 1;
The DATA disk group has 50GB free space.
Which two are prerequisites for successful execution of this command?

A. The DATA disk group must not contain any other volume.

B. COMAPTIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the DATA disk group.

C. The DATA disk group must have an AU size of 1MB.

D. The DATA disk group must not be created with external redundancy.

E. The DATA disk group must have at least three failure groups.

Discussion 0

Correct Answer: B,E Vote an answer

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

Question 4

You must replace a failed disk that was dropped from a disk group.
You want the rebalance operation to occur with minimal performance impact.
Which two options exist to achieve this? (Choose two.)

A. Set the POWER clause to 1 in the ALTER DISKGROUP command.

B. Make sure that the ASM_POWER_LIMIT parameter is set to 1 before rebalancing the disk group.

C. Use the WAIT clause with the ALTER DISKGROUP command.

D. Increase the value of the DISK_REPAIR_TIME attribute for the disk group.

E. Decrease the value of the DISK_REPAIR_TIME attribute for the disk group.

Discussion 0

Correct Answer: B,D Vote an answer

Question 5

Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 12c RAC?

A. In a RAC database, there is no LMD0 process if only one instance is running.

B. Global Enqueues may have owners and waiters in the same instance.

C. In a RAC One Node database, there is no LMD0 process if only one instance is running.

D. Global Enqueues and Instance Locks replace latches completely in RAC database instances.

E. Global Enqueues may have converters and waiters in the same instance.

F. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.

Discussion 0

Correct Answer: C,E Vote an answer

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

Question 6

Which three statements are true about ASM Cloud File System (ACFS) auditing?

A. acfsutil audit purge can be run by an audit manager.

B. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.

C. acfsutil audit archive must be used to archive audit files that are larger than 10MB.

D. acfsutil audit read marks audit files to indicate that it is safe to purge them.

E. acfsutil audit init must be run by a system administrator.

Discussion 0

Correct Answer: A,D,E Vote an answer

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

Question 7

Which three statements are true concerning backups of the OCR and OLR in Oracle Clusterware 12c? (Choose three.)

A. The OLR can be backed up using ocrconfig.

B. The OLR is backed up automatically every four hours.

C. The OCR is backed up by default to a cluster file system location.

D. The OCR can be backed up using ocrconfig.

E. The OCR is backed up automatically every four hours.

F. The OLR is backed up by default to a cluster file system location.

Discussion 0

Correct Answer: A,D,F Vote an answer

Question 8

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

A. a resource dependency definition

B. A Server Pool

C. an application VIP

D. an application resource

E. a script agent

Discussion 0

Correct Answer: D,E Vote an answer

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

Question 9

Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

A. One QoS policy can span multiple clusters if they contain server pools, assigned to be managed by QoS.

B. It requires a resource manager plan to be active on databases managed by QoS.

C. A server pool directive override can be used to modify the database parameter CPU_COUNT for all databases within one server pool.

D. The command-line utility qosct1 can be used to change the password of the internal user QOSADMIN.

E. It supports RAC One Node databases if they are assigned to server pools with a maximum size of one server.

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 10

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. ASM instances continue running on all three nodes until all database instances connected to one of the ASM instances shut down.

B. The command fails because the instance count cannot be reduced to less than the minimum value of 3.

C. One ASM instance is shut down and the instance count is reduced by one.

D. The command fails because one ASM instance must be shut down manually before executing the command.

Discussion 0

Correct Answer: C Vote an answer

Question 11

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

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

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

C. The upgrade must be done out of place.

D. The upgrade must be done in-place.

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

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

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

Discussion 0

Correct Answer: B,C,F,G Vote an answer

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

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

Contact Us

Useful Links

Latest Updated