單項選擇題

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

你可能感興趣的試題

多項選擇題

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.

單項選擇題

These are points that describe the contents of different memory components:
1: Descriptive information or metadata about schema objects that are queried by using SQL statements
2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements
3: Results of SQL queries and PL/SQL functions
4: Executable forms of SQL cursors, PL/SQL programs, and Java classes
5: The information necessary to reconstruct changes made to the database by a transaction
Which of these will be stored in theShared Poolif the necessary configurations are done（）

A.1 and 2
B.2 and 5
C.1，3，and 4
D.3，4，and 5
E.1，2，3，and 4

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

你可能感興趣的試題

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

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久