多項選擇題

Which two statements about the background process of thedatabase writerare true（）

A.It is possible to have multiple database writers in an Oracle instance.
B.It writes dirty buffers， if any， to data files whenever a checkpoint occurs.
C.It writes dirty buffers， if any， to data files whenever a transaction commits.
D.It writes dirty buffers， if any， to data files before the log writer （LGWR） writes.

你可能感興趣的試題

單項選擇題

View the Exhibit and identify the component marked with a question mark. （）

A.Checkpoint （CKPT）
B.Process Monitor （PMON）
C.Archiver Processes （ARCn）
D.Recoverer Process （RECO）
E.Memory Manager process （MMAN）

單項選擇題

Note the functionalities of various background processes：
1：Perform recovery at instance startup. SMON
2：Free the resources used by a user process when it fails. PMON
3：Cleanup the database buffer cache when a process fails. PMON
4：Dynamically register database services with listeners. PMON
5：Monitor sessions for idle session timeout. PMON
6：Cleanup unused temporary segments. SMON
7：Record the checkpoint information in control file. CKPT
Which option has the correct functionalities listed for a background process（）

A.Checkpoint （CKPT）： 1， 2， 5
B.System Monitor （SMON）： 1， 6
C.Process Monitor （PMON）： 4， 6， 7
D.Database Writer （DBWR）： 1， 3， 4

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

Which two statements about the background process of thedatabase writerare true（）

你可能感興趣的試題

View the Exhibit and identify the component marked with a question mark. （）