單項(xiàng)選擇題

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

你可能感興趣的試題

單項(xiàng)選擇題

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

A.Archiver Process （ARCn）：1， 2，5
B.System Monitor Process （SMON）：1，4，5
C.Process Monitor Process （PMON）：4，5，6
D.Database Writer Process （DBWn）：1，3，4

多項(xiàng)選擇題

Which two statements are true about Shared SQL Area and Private SQL Area（）

A.Shared SQL Area will be allocated in the shared pool.
B.Shared SQL Area will be allocated when a session starts.
C.Shared SQL Area will be allocated in the large pool always.
D.Private SQL Area will be allocated in the Program Global Area （PGA） always.
E.Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
F.The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

Which two statements are true about Shared SQL Area and Private SQL Area（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线