Oracle Database Administration 2019 Certified Professional — Question 29

Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)

Answer options

• A. Only one GRD shadow resource may exist for an Enqueue Resource.
• B. Shadow GRD resources may exist in more than one database instance for a resource.
• C. Clustered ASM has GRD resources distributed among all ASM instances.
• D. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
• E. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
• F. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
• G. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.

Correct answer: B, C, G

Explanation

Option B is correct because shadow GRD resources can be associated with multiple database instances. Option C is also correct as Clustered ASM does indeed distribute GRD resources across all ASM instances. Option G is correct since RAC databases store GRD cache resources in the shared pool of each instance, while options A, D, E, and F contain inaccuracies regarding the distribution and storage of GRD resources.