Oracle Database 12c: RAC Administration — Question 21

Which three statements are true about the Global Enqueue Service and Global Enqueue Service (GES) Resources in Oracle 12c RAC?

Answer options

• A. The mastering instance for a GES resource is never the same as the instance that owns the enqueue in exclusive mode.
• B. The LMD0 runs only on the instance that masters all GES resources.
• C. When a GES resource is dequeued, converters if any exist for that resource, are processed before any waiter for that resource.
• D. The LMD0 process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.
• E. The mastering instance for a GES resource is never the same as the instance that owns an enqueue in shared mode.
• F. An LMD0 process runs on all instances.
• G. The foreground process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.

Correct answer: D, E, G

Explanation

The correct answer includes D, E, and G because they accurately describe the interactions and roles of the LMD0 process and GES resources in Oracle 12c RAC. Options A, B, and F are incorrect as they misrepresent the responsibilities and distribution of the LMD0 process across instances and the ownership of GES resources.