Which two statements are true about Flex ASM in a Flex Cluster?
Correct Answer: AC
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.
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: AC
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.
You just added an ASM disk to the DATA diskgroup.
Which two can be used to monitor the rebalancing?
Correct Answer: CE
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.
Which two statements are true about initialization parameters for Clustered ASM instances?
Correct Answer: CE
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.
Which two statements are true about the UNDROP clause of the ALTER DISKGROUP statement?
Correct Answer: BD
The UNDROP DISKS clause of the ALTER DISKGROUP statement cannot be used to restore disks that are being dropped as the result of a DROP DISKGROUP statement. This means that once a disk is part of a disk group that is being dropped, it is lost permanently and cannot be re-added through the undrop mechanism. Additionally, it is not possible to cancel pending drops of disks that were dropped using the FORCE clause, as this clause indicates an immediate and irreversible action. Therefore, both these statements are correct.