Oracle Exam 1Z0-497 Topic 1 Question 12 Discussion

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

Question #: 12
Topic #: 1

[All 1Z0-497 Questions]

Which three events signal a database writer (DWR) to write buffers to disk?

AThe database advances a checkpoint.

BA client process commits a transaction.

CThe redo log buffer becomes full.

DA server process cannot find non-dirty blocks after scanning a threshold number of buffers.

EA tablespace is changed to read-only status.

FThe database is shut down in immediate mode.

Show Suggested Answer

Suggested Answer: A, D, F

When tablespace is changed to read only status it will issue a Partial checkpoint. During db shutdown a checkpoint is also issued. DWR writes when there is a checkpoint.

by Theola at May 08, 2022, 04:30 AM

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!