Exam 1z0-078 topic 1 question 64 discussion

Actual exam question from Oracle's 1z0-078

Question #: 64
Topic #: 1

[All 1z0-078 Questions]

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

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.

Show Suggested Answer

Suggested Answer: AE 🗳️

by [deleted] at April 4, 2025, 10:24 a.m.

Comments

Submit Cancel

shaw2000

23 hours, 35 minutes ago

Selected Answer: AE

CR (Consistent Read) image: A CR image is created when a block needs to be read in a consistent state (e.g., for a query). If another instance requests the block for a read, the CR image can be shipped from one instance to another. So A is correct. XCUR (Exclusive Current) image: This is the current version of the block held exclusively by one instance for updates. Only one instance can have an XCUR image for a specific block at any time. So E is correct.

upvoted 1 times

...