单选题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
单选题
The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.
A
large pool
B
shared pool
C
data buffer cache
D
redo log buffer
E
data dictionary cache
参考解析
解析：
暂无解析
相关考题：
The sending or conveying of information from one place to another is the process ofA NetworkingB TransmittingC InteractingD PromotingE Interfacing
95 The sending or conveying of information from one place to another is the process ofA. NetworkingB. TransmittingC. InteractingD. PromotingE. Interfacing
You are currently in the process of creating an application that reads binary information from a file.You need to ensure that the only the first kilobyte of data is retrieved.What should you do?() A.B.C.D.
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）A、 DBWnB、 RECOC、 RVWRD、 LGWR
Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.
You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）A、Writes buffers to disk B、Writes current redo log number to datafile headers C、Writes redo log information to disk D、Reads information into memory for users
Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database？ （）A、SYNC or ASYNC to identify the network transmission mode. B、LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby. C、AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously. D、PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）A、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer
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
A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）A、 The database re-created the missing redo log files automatically.B、 The database continues to function normally with the existing files.C、 The database allows only queries， no other statements are allowed.D、 The database returns and error and the database instance shuts down.E、 The user sessions that generate redo logs are terminated automatically.
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 background process reads the redo log buffer and writes it to a file？（）A、ARCnB、DBWnC、CKPTD、LGWRE、PMONF、SMON
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.
The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（） A、 The database will hang.B、 The database will be crashed.C、 The database will be shut down.D、 The LGWR process writes redo log entries to the other redo log member of the Group2 group
You have a Web server that runs Windows Server 2003 Service Pack 2 (SP2). You need to collect the following information from the Web server: Unauthorized attempts to upload filesUnsuccessful commands that try to run executables You must achieve this goal by using the minimum amount of administrative effort. What should you do?（）A、From Network Monitor， start a capture.B、From the Performance snap-in， create a counter log.C、From Internet Information Services （IIS） Manager， enable logging.D、From Computer Management， modify the properties of the application log.
单选题The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（）A The database will hang.B The database will be crashed.C The database will be shut down.D The LGWR process writes redo log entries to the other redo log member of the Group2 group
单选题Your database is in NOARCHIVELOG mode. The database has three online redo log groups， and each group contains three online redo log members. The online redo log members are stored across three hard disks， E， F， and G， respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database？（）A The database will operate normally without generating any redo.B The database will hang， and you must shut down and restart the instance.C The database will crash， and you must recover the database from the point of failure.D The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.
多选题Which two statements about the background process of thedatabase writerare 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.
多选题You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer. Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance？（）AIncrease the size of redo log filesBIncrease the size of redo log bufferCIncrease the number of redo log filesDPlace the redo log files on a separate diskEDecrease the number of redo log groups to twoFIncreate the number Log Writer （LGWR） process
多选题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
单选题You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）AWrites buffers to disk BWrites current redo log number to datafile headers CWrites redo log information to disk DReads information into memory for users
单选题Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）A DBWnB RECOC RVWRD LGWR
单选题A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）A The database re-created the missing redo log files automatically.B The database continues to function normally with the existing files.C The database allows only queries， no other statements are allowed.D The database returns and error and the database instance shuts down.E The user sessions that generate redo logs are terminated automatically.
单选题Which background process reads the redo log buffer and writes it to a file？（）AARCnBDBWnCCKPTDLGWREPMONFSMON
多选题Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）AarchivalBlog writerCdatabase writerDsystem monitorEprocess monitorFchange tracking writer
多选题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.