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

Question 1

Which three types of patches and upgrades are supported for Oracle Grid Infrastructure 12c? (Choose three.)

A. in-place patching for one-off patches

B. in-place upgrades using the Oracle Universal Installer

C. in-place patching for patch sets

D. out-of-place upgrades using the Oracle Universal Installer

E. out-of-place patching for patch bundles

F. in-place patching for patch bundles

Discussion 0

Correct Answer: A,D,E Vote an answer

Question 2

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 3

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

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

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

C. It installs the OpenSSH client package.

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

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

Discussion 0

Correct Answer: A,B Vote an answer

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

Question 4

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. Transparent Application Failover (TAF) using Fast Application Notification (FAN)

B. Fast Connection Failover (FCF)

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

D. Transparent Application Failover (TAF)

Discussion 0

Correct Answer: A Vote an answer

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

Question 5

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 6

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 7

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 succeeds but leaves the filesystem unmounted.

B. It resizes VOL1.

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 the filesystem mounted on /u01/app/grid/acfsmount.

Discussion 0

Correct Answer: A,B Vote an answer

Question 8

Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?

A. Taking an AWR snapshot in a RAC database captures data from all instances that have the database opened.

B. Taking an AWR snapshot in a RAC database captures data from the local instance only.

C. The awr_snapshot_time_offset parameter specifies the number of seconds each instance waits after the top of the hour before taking its AWR snapshot.

D. AWR snapshots are created when control_management_pack_access is set to "none"

E. Data captured by an AWR is aggregated across all instances before being stored in the database.

Discussion 0

Correct Answer: A,C,D Vote an answer

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

Question 9

Examine this command and output:

Examine this list of commands:
1. srvct1 convert db -db ron -dbtype rac -node o16n1
2. srvct1 convert db -db ron -dbtype raconenode -node 016n1
3. srvct1 add instance -db ron -instance ron_1 -node 016n1
4. srvct1 add instance -db ron -in5tance ron_2 -node 016n2
5. srvct1 start instance -db ron -instance ron_1
6. srvct1 start instance -db ron -instance ron_2
Currently, there is an instance of database ron running on o16n1.
You want to convert ron to a RAC database and make all instances available.
Identify the commands required, in the correct order, to accomplish this.

A. 1, 4, 5 and 6

B. 2, 4, 5 and 6

C. 2, 3, 4, 5 and 6

D. 1, 4 and 6

E. 2, 4 and 6

F. 1, 3, 4, 5 and 6

Discussion 0

Correct Answer: F Vote an answer

Question 10

Which two statements are true about vsam views in a clustered environment
?

A. Their names can be seen in dict when connected to an ASM instance.

B. gvasm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.

C. Their names can be seen in vfixed_table when connected to an instance of any type that is started.

D. They exist both in ASM and RDBMS instances, and display the same output.

E. They exist in both in ASM and RDBSM instances, but they can display different outputs depending on the instance type.

Discussion 0

Correct Answer: A,E Vote an answer

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

Question 11

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

A. acfssettag is a command provided by a platform-independent API to tag files.

B. ACFS tagging is used to mark a subset of files in an ACFS file system for replication.

C. acfssettag is a command provided by a platform-dependent API to tag files.

D. acfsutil tag set can be used to tag files.

E. acfsutil encr on can be used to specify the tag names of the files to be encrypted.

Discussion 0

Correct Answer: A,B,D Vote an answer

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

Question 12

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

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

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

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

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

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

Discussion 0

Correct Answer: B,C,D Vote an answer

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

Question 13

PROD1, PROD2 and PROD3 are three instances that have multitenant container database PROD open.
PROD contains multiple PDBs.
Examine these successful commands:
$ srvctl add service -db PROD -pdb PRDPDB1 -service SRVPDB1
$ srvctl start service -db PROD -service SRVPDB1
Which statement is true about the srvctl start service command?

A. It opens the PRDPDB1 PDB if not already opened.

B. It can open the PRDPDB1 PDB only if it is manually managed.

C. It can open the PRDPDB1 PDB only if it is policy managed.

D. It cannot open the PRDPDB1 PDB automatically.

Discussion 0

Correct Answer: C Vote an answer

Question 14

Which three statements are true about fully qualified file names in ASM? (Choose three.)

A. An alias may be created for an existing le by referring to the fully qualified file name.

B. They can be used to reference existing ASM files.

C. They can be created only if OMF is enabled.

D. They are the only valid form that can be used for single file creation of a control file.

E. They are system generated at the time of ASM file creation.

Discussion 0

Correct Answer: A,B,E Vote an answer

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

Contact Us

Useful Links

Latest Updated