Notethefunctionalitiesofvariousbackgroundprocesses： 1：P

1Z0-052

单项选择题

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

相关考题

单项选择题 Notethefollowingfunctionalitiesofvariousbackgroundprocesses： 1：Record thecheckpointinformationindatafileheaders.CKPT 2：Performrecoveryatinstancestartup.SMON 3：Cleanupunusedtemporarysegments.SMON 4：Freetheresourcesusedbyauserprocesswhenitfails. 5：Dynamicallyregisterdatabaseserviceswithlisteners. 6：Monitorsessionsforidlesessiontimeout. Whichoptionhasthecorrectfunctionalitieslistedforabackgroundprocess（）

多项选择题 WhichtwostatementsaretrueaboutSharedSQLAreaandPrivateSQLArea（）

单项选择题 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（）