单项选择题
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)
相关考题
-
单项选择题
Notethefunctionalitiesofvariousbackgroundprocesses: 1:Performrecoveryatinstancestartup.SMON 2:Freetheresourcesusedbyauserprocesswhenitfails.PMON 3:Cleanupthedatabasebuffercachewhenaprocessfails.PMON 4:Dynamicallyregisterdatabaseserviceswithlisteners.PMON 5:Monitorsessionsforidlesessiontimeout.PMON 6:Cleanupunusedtemporarysegments.SMON 7:Recordthecheckpointinformationincontrolfile.CKPT Whichoptionhasthecorrectfunctionalitieslistedforabackgroundprocess()
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()
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 -
多项选择题
WhichtwostatementsaretrueaboutSharedSQLAreaandPrivateSQLArea()
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.
