Multiple choice

What is the difference between I/O slaves and DBWn processes for the DB Writer?

  1. In Oracle8i, I/O slaves are not available; only DBWn processes are available.

  2. I/O slaves perform the write function only, while DBWn processes also perform date-gathering activity.

  3. I/O slaves will work only with synchronous I/O, whereas DBWn processes are available only within asynchronous I/0.

  4. I/O slaves will work only with asynchronous I/O, whereas DBWn processes are available only within synchronous I/0.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

I/O slaves are specialized processes that only perform write operations to data files. DBWn (Database Writer) processes perform both data gathering (identifying dirty buffers) and writing them to disk. The synchronous/asynchronous I/O distinction is incorrect - both can work with either type.

Keep practicing — related questions