CKPT
SMON
LGWR
DBWn
ARCn
第1题:
Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener?()
第2题:
Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()
第3题:
A. CKPT
B. SMON
C. MMON
D. DBWR
第4题:
You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process. Which action will enable you to disable the trace files generated by the ARCn background process?()
第5题:
Which Oracle background process frees SGA resources that were allocated to a user process that failed?()
第6题:
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()
第7题:
Which statements are true about checkpointing()
第8题:
A.CKPT
B.SMON
C.LGWR
D.DBWn
E.ARCn
第9题:
Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?()
第10题:
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()