网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
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.


参考答案

参考解析
解析: 暂无解析
更多 “多选题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.” 相关考题
考题 You work as a database administrator for Certkiller .com. You received the following error while working on your database: ORA-01555: snapshot too old  In which situation would you receive such an error?()A、You performed rollback after commit.B、If a log switch occurs in your database.C、Thearchiverfails to generate an archived log file.D、Instance recovery fails to find one of the redo log files.E、A long-running query is unable to get read-consistent image.F、If you perform manual undo management operations in auto mode.

考题 Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()A、 DBWnB、 RECOC、 RVWRD、 LGWR

考题 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.

考题 You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file.  How does the loss of a redo log member affect the instance of the database that is currently running?()A、The instance would normally abort.B、The instance would not be affected.C、The instance would be invalid, so would have to be aborted.D、The instance would remain open, but the LGWR process would fail.E、The instance would remain open and would automatically create the missing file

考题 In your production database, you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation, you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server?()A、increase the size of the redo log bufferB、increase the number of redo log groupsC、increase the number of log writer processesD、increase the number of ARCn processesE、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

考题 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 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

考题 单选题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.

考题 多选题In your production database, you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation, you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server?()Aincrease the size of the redo log bufferBincrease the number of redo log groupsCincrease the number of log writer processesDincrease the number of ARCn processesEchange the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

考题 多选题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

考题 单选题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

考题 单选题Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further?()A RECOVER LOGFILE BLOCK GROUP 2;B ALTER DATABASE DROP LOGFILE GROUP 2;C ALTER DATABASE CLEAR LOGFILE GROUP 2;D ALTER DATABASE RECOVER LOGFILE GROUP 2;E ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;

考题 多选题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?()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 background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()A  DBWnB  RECOC  RVWRD  LGWR

考题 单选题You work as a database administrator for Supportcenter.cn. You received the following error while working on your database: ORA-01555: snapshot too old ,In which situation would you receive such an error?()A You performed rollback after commit.B If a log switch occurs in your database.C Thearchiverfails to generate an archived log file.D Instance recovery fails to find one of the redo log files.E A long-running query is unable to get read-consistent image.F If you perform manual undo management operations in auto mode.

考题 单选题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.

考题 单选题You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file.  How does the loss of a redo log member affect the instance of the database that is currently running?()A The instance would normally abort.B The instance would not be affected.C The instance would be invalid, so would have to be aborted.D The instance would remain open, but the LGWR process would fail.E The instance would remain open and would automatically create the missing file

考题 多选题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

考题 单选题You work as a database administrator for Certkiller .com. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk.  Which command would you execute to proceed further?()A RECOVER LOFIEL BLOCK GROUP 2;B ALTER DATABASE DROP LOGFILE GROUP 2;C ALTER DATABASE CLEAR LOGFILE GROUP 2;D ALTER DATABASE RECOVER LOGFILE GROUP 2;E ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;