TheLogWriter(LGWR)processreadsinformationfromthe()andwritesittotheonlinelogs. A.largepoolB.sharedpoolC.databuffercacheD.redologbufferE.datadictionarycache
TheLogWriter(LGWR)processreadsinformationfromthe()andwritesittotheonlinelogs.
A.largepool
B.sharedpool
C.databuffercache
D.redologbuffer
E.datadictionarycache
相关考题：
Inyourdatabase,theLogWriter(LGWR)processisunabletowritetoamemberofacurrentredologgroupduetoread／writefailure.Whichtwoeffectswouldyouseeinyourdatabase?() A.Thedatabaseinstanceaborts.B.Thedatabaseoperationtemporarilyhaltstillthememberbecomesavailable.C.Writingproceedsasnormal.LGWRwritestotheavailablemembersofagroupandignorestheunavailablemembers.D.ThememberwouldbemarkedasSTALEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.E.ThestatusofthegroupchangestoINACTIVEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.
Whichtwostatementsaboutthebackgroundprocessofthedatabasewriteraretrue() A.ItispossibletohavemultipledatabasewritersinanOracleinstance.B.Itwritesdirtybuffers，ifany，todatafileswheneveracheckpointoccurs.C.Itwritesdirtybuffers，ifany，todatafileswheneveratransactioncommits.D.Itwritesdirtybuffers，ifany，todatafilesbeforethelogwriter（LGWR）writes
WhichbackgroundprocesssequentiallywritesFlashbackDatabasedatafromtheflashbackbuffertotheFlashbackDatabaselogs?() A.DBWnB.RECOC.RVWRD.LGWR
Amediafailurehasoccurred.Thishasresultedinallthemembersofthenextloggroupbeingrenderedinaccessibletothelogwriterprocess(LGWR)atalogswitch.Howdoesthisfailureaffecttheoperationaldatabase?() A.Thedatabaseallowsonlyqueries；nootherstatementsareallowed.B.Thedatabasere-createsthemissingredologfilesautomatically.C.Thedatabasecontinuestofunctionnormallywiththeexistingfiles.D.Thedatabasereturnsanerrorandthedatabaseinstanceshutsdown.E.Theusersessionsthatgenerateredologsareterminatedautomatically.
LGWR进程将自上次写入磁盘以来的全部日志项输出，LGWR输出（）。A、当用户进程提交一事务时写入一个提交记录B、每十秒将日志缓冲区输出C、当日志缓冲区的1／2已满时将日志缓冲区输出D、当DBWR将修改缓冲区写入磁盘时则将日志缓冲区输出E、每一分钟将日志缓冲区输出
下面关于COMMIT命令说法错误的是（）。A、执行COMMIT命令时，LGWR不会进行任何操作B、执行COMMIT命令时，DBWn不会进行任何操作C、执行COMMIT命令时发生的所有物理操作是LGWR进程将日志缓冲区的内容写入磁盘D、当满足某些条件时，DBWn进程会将脏缓冲区写入磁盘
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）A、 DBWnB、 RECOC、 RVWRD、 LGWR
The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.A、large poolB、shared poolC、data buffer cacheD、redo log bufferE、data dictionary cache
During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?（）A、DBW0 B、LGWR C、ARCH D、SMON E、PMON
In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）A、The database instance aborts.B、The database operation temporarily halts till the member becomes available.C、Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.D、The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.E、The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
Which two statements about the background process of the database writer are true（）A、It is possible to have multiple database writers in an Oracle instance.B、It writes dirty buffers， if any， to data files whenever a checkpoint occurs.C、It writes dirty buffers， if any， to data files whenever a transaction commits.D、It writes dirty buffers， if any， to data files before the log writer （LGWR） writes
Which two statements about the background process of thedatabase writerare true（） A、It is possible to have multiple database writers in an Oracle instance.B、It writes dirty buffers， if any， to data files whenever a checkpoint occurs.C、It writes dirty buffers， if any， to data files whenever a transaction commits.D、It writes dirty buffers， if any， to data files before the log writer （LGWR） writes.
ORACLE数据库启动后，有哪五个必要的后台进程（mandatory background processes）（）A、CKPT DBWn LGWR PMON SMONB、ARCn CKPT DBWn LGWR SMONC、CJQ0 CKPT DBWn LGWR SMOND、DBWn LGWR PMON RECO SMONE、CKPT DBWn LMON PMON SMON
单选题The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.Alarge poolBshared poolCdata buffer cacheDredo log bufferEdata dictionary cache
多选题Which two statements about the background process of the database writer are true（）AIt is possible to have multiple database writers in an Oracle instance.BIt writes dirty buffers， if any， to data files whenever a checkpoint occurs.CIt writes dirty buffers， if any， to data files whenever a transaction commits.DIt writes dirty buffers， if any， to data files before the log writer （LGWR） writes
单选题ORACLE数据库启动后，有哪五个必要的后台进程（mandatory background processes）（）ACKPT DBWn LGWR PMON SMONBARCn CKPT DBWn LGWR SMONCCJQ0 CKPT DBWn LGWR SMONDDBWn LGWR PMON RECO SMONECKPT DBWn LMON PMON SMON
单选题Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）A DBWnB RECOC RVWRD LGWR
多选题In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）AThe database instance aborts.BThe database operation temporarily halts till the member becomes available.CWriting proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.DThe member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.EThe status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.