Oracle Database 12c: RAC Administration — Question 56

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

Answer options

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

Correct answer: B, D

Explanation

Option B is correct because the names of vsam views can indeed be observed in the dict when connected to an ASM instance. Option D is also accurate as vsam views can vary in output depending on the instance type. The other options are incorrect; A falsely claims identical outputs, C inaccurately states the visibility of names across all instance types, and E does not pertain directly to vsam views.