Oracle Database 12c RAC and Grid Infrastructure Administration

Here you have the best Oracle 1z0-068 practice exam questions

You have 61 total questions to study from
Each page has 5 questions, making a total of 13 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on November 22, 2024

Question 1 of 61

Which two statements are true regarding ASM Dynamic Volume manager (ADVM)?

To create an ADVM volume, disk group attributes COMAPTIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.

An ADVM volume is individually named and can contain only one file system.

Only one ADVM volume can be created in an ASM disk group.

ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.

File systems contained in ADVM volumes may only contain database files.

Correct Answer: B, D

To create an ASM Dynamic Volume (ADVM), certain statements hold true. First, each ADVM volume is individually named and can contain only one file system, aligning with standard file system management practices. Additionally, ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group, allowing for more flexible storage configurations and usage within an ASM environment.

Question 2 of 61

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

ACFS auditing information is replicated from the primary file system to the standby file system.

One site of an ACFS replication configuration can be host both primary and standby file systems.

Replication is automatically terminated if the primaries file system has less than 2GB free space.

Standby redo log files are required on the standby site for synchronous redo transport.

The privilege SYSREPL has been introduced for ACFS replication.

Correct Answer: A, B, C

ACFS auditing information is replicated from the primary file system to the standby file system. One site of an ACFS replication configuration can host both primary and standby file systems, providing flexibility in storage management. Replication is automatically terminated if the primary file system has less than 2GB free space to prevent running out of disk space during replication. Standby redo log files are not a requirement for ACFS replication.

Question 3 of 61

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?

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

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

The DATA disk group must not contain any other volume.

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

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

Correct Answer: A, B

COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for creating a volume. A highly redundant disk group cannot be created with external redundancy. Although a high redundancy disk group needs three failure groups, there is no requirement that the DATA disk group must have at least three failure groups, only that it cannot have external redundancy. Therefore, A and B are correct prerequisites.

Question 4 of 61

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

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

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

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

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

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

Correct Answer: A, D

VSAM views exist both in ASM and RDBMS instances and can display different outputs depending on the instance type. This means that the environment in which they are used can influence the output of the views.

Question 5 of 61

Which two statements are true about ASM default templates?

Default data file templates are only created by ASM when a normal redundancy disk group is created.

Default template settings for redundancy depends on the disk group redundancy.

Default templates for a disk group can be modified.

Default template setting for striping depends on disk group redundancy.

Templates may be shared across disk groups.

Correct Answer: B, C

ASM (Automatic Storage Management) provides default templates for setting file attributes such as redundancy and striping. These templates depend on the specific disk group type; for instance, default template settings for redundancy will vary based on whether the disk group is set up with normal or high redundancy. Additionally, Oracle ASM allows administrators to modify these default templates according to their requirements.