Oracle Database Administration 2019 Certified Professional — Question 80

Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 19c RAC? (Choose two.)

Answer options

• A. A CR image may get served from one instance to another to satisfy a read request.
• B. An XCUR image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.
• C. An XCUR image is not shipped to another instance until commits occur for updated rows on the block.
• D. A PI block image may exist for a specific database block in only one instance.
• E. An XCUR block image may exist for a specific database block in only one instance.

Correct answer: A, E

Explanation

Option A is correct because a CR image can indeed be served across instances to fulfill read requests in a RAC environment. Option E is also correct as an XCUR block image can exist in only one instance at a time. Options B, C, and D are incorrect because they either misrepresent the behavior of XCUR images or the nature of PI block images in a RAC setup.