Oracle Database Administration 2019 Certified Professional — Question 2

Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)

Answer options

• A. Database block buffers
• B. Mutexes
• C. Redo log buffers
• D. Latches
• E. Enqueues
• F. Cursors

Correct answer: B, D, E

Explanation

The correct answers are B, D, and E because Mutexes, Latches, and Enqueues are all mechanisms used to manage concurrent access to resources in a RAC environment. Options A, C, and F are not directly managed by global concurrency control, as Database block buffers and Redo log buffers relate to data storage rather than concurrency, and Cursors pertain to SQL statement execution, which is not controlled globally.