Question 6 of 62

Which two statements are true about Flex ASM in a Flex Cluster?

    Correct Answer: A, C

    Oracle databases from releases older than 12c cannot use Flex ASM due to its reliance on features introduced in Oracle Database 12c. Additionally, instances of ASM-based databases on hosts that have no ASM instance running require Flex ASM to manage storage without a local ASM instance. These statements are accurate within the scope of Flex ASM in a Flex Cluster.

Question 7 of 62

A directory +DATA/ORCL/DATAFILE/USERS exists in ASM.

USERS is a user created directory; ORCL and DATAFILE are system generated directories.

Which two statements are true about user-created directories?

    Correct Answer: A, C

    User-created directories in ASM allow for the creation of subdirectories, which makes option A correct. Additionally, you cannot drop a directory containing aliases without deleting the aliases first, making option C correct. Restrictions such as not being able to create a user-defined directory at the root (+) level or limitations on nesting subdirectories with single commands are not among the general rules, thus options D and E are incorrect.

Question 8 of 62

You just added an ASM disk to the DATA diskgroup.

Which two can be used to monitor the rebalancing?

    Correct Answer: C, E

    To monitor the rebalancing of an ASM disk added to the DATA diskgroup, the appropriate views to consult are v$asm_operation, which shows information about ongoing ASM operations, and v$session_longops, which provides details on long-running operations including rebalancing activities. v$asm_operation directly provides the current status and details of rebalancing, while v$session_longops gives a broader perspective on long-running tasks involving the database.

Question 9 of 62

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

    Correct Answer: C, E

    The ASM_DISKGROUP parameter is optional because the default value is a NULL string. This means ASM does not mount any disk groups if the parameter value is NULL or not specified. Additionally, the ASM_POWER_LIMIT initialization parameter, which specifies the default power for disk rebalancing in a disk group, has a range of values from 0 to 1024. This range confirms that the maximum value is indeed 1024.

Question 10 of 62

Examine this command:

SQL> CREATE DISKROUP data NORMAL REDANDUNCY:

FAILGROUP fgrpl DISK -

/dev/disk1 NAME disk1,

/dev/disk2 NAME disk2,

/dev/disk3 NAME disk3,

FAILGROUP fgrpl2 DISK -

/dev/disk4 NAME disk4,

/dev/disk5 NAME disk5,

/dev/disk6 NAME disk6,

FAILGROUP fgrpl3 DISK -

/dev/disk7 NAME disk7,

/dev/disk8 NAME disk8,

/dev/disk9 NAME disk9,

ATTRIBUTE au_size=4M,

compatible.asm = 11.2,

compatible.rdbms = 11.2,

compatible.advm = 11.2,

content_type = recovery;

Which two statements a true about this disk group, created using Grid Infrastructure 12.1?

    Correct Answer: C, D