In which situations does the Database Writer process (DBWn) write to data files?
A.
when the RMAN recovery process starts
B.
when a user process commits a transaction
C.
when a tablespace is made read-only or taken offline
D.
when PMON cleans up dirty buffers in the database buffer cache
E.
when clean buffers for reading new blocks into the database buffer cache are not found easily
Explanation:
https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm
I think it should be C. Not D
The DBWn background process writes to the data fles whenever one of the following
events occurs:
■■ A user’s server process has searched too long for a free buffer when reading a buffer
into the buffer cache
■■ The number of modifed and committed, but unwritten, buffers in the database buffer cache is too large
■■ At a database checkpoint event See Chapter 16 for information on checkpoints
■■ The instance is shut down using any method other than a shutdown abort
■■ A tablespace is placed into backup mode
■■ A tablespace is taken offline to make it unavailable or is changed to READ ONLY
■■ A segment is dropped
I agree with Trung. It should be C.