Oracle Database Administration 2019 Certified Professional — Question 27

Which two statements are true about v$asm- views in a clustered environment? (Choose two.)

Answer options

• A. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
• B. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
• C. Their names can be seen in dict when connected to an ASM instance.
• D. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
• E. They exist in both ASM and RDBMS instances, and display the same output.

Correct answer: A, B

Explanation

Option A is correct because v$asm views can indeed provide different outputs in ASM and RDBMS instances. Option B is also correct as v$fixed_table contains the names of these views when connected to any instance. Options C, D, and E are incorrect; C is not universally true, D is misleading as gv$asm_attribute pertains to specific instances rather than all, and E contradicts the established differentiation in outputs.