Oracle Exam 1Z0-497 Topic 8 Question 9 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 9
Topic #: 8

You connect to a database instance and execute a DML command that changes one data block. The block is read from the buffer cache, modified, and modified, and marked as dirty. You commit the transaction. What must take place before the block can be written to disk?

AThe buffer must be written to flash cache.

BA log writer (LGWR) must write all redo entries that have been copied into the buffer since the last time it wrote.

CThe modified data block must be moved from the LRU list to the write queue.

DThe database must advance the checkpoint.

Show Suggested Answer

Suggested Answer: B

by Stephaine at May 04, 2022, 06:00 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-497 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!