网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which background process reads the redo log buffer and writes it to a file？（）
A
ARCn
B
DBWn
C
CKPT
D
LGWR
E
PMON
F
SMON
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which background process reads the redo log buffer and writes it to a file？（）A ARCnB DBWnC CKPTD LGWRE PMONF SMON” 相关考题
考题
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）A、 DBWnB、 RECOC、 RVWRD、 LGWR
考题
You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）A、 recycle buffer cacheB、 large poolC、 streams poolD、 keep buffer cacheE、 redo log buffer
考题
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 statements are true about checkpointing（）A、The checkpoint frequency decreases with the smaller redo log file size.B、It ensures that all committed data is written to the data files during normal shutdown.C、The frequent full checkpoint in a database can cause the overall degradation of the database performance.D、It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the onlineredo log files
考题
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
考题
Which two statements are true about checkpointing（）A、The checkpoint frequency decreases with the smaller redo log file size.B、It ensures that all committed data is written to the data files during normal shutdown.C、The frequent full checkpoint in a database can cause the overall degradation of the database performance.D、It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.
考题
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 background process reads the redo log buffer and writes it to a file？（）A、ARCnB、DBWnC、CKPTD、LGWRE、PMONF、SMON
考题
Which background process is responsible for writing the dirty buffers from the write list to the data files during a checkpoint？（）A、CKPTB、SMONC、LGWRD、DBWnE、ARCn
考题
Which component of the SGA stores parsed SQL statements is used for process sharing?（）A、Buffer cache B、Redo log buffer C、Private SQL area D、Library cache E、Row cache
考题
Which statement is true about FLUSH LOGS command?（）A、It requires the RELOAD, FILE, and DROP privilegesB、It closes and reopens all log filesC、It closes and sends binary log files to slave serversD、It flushes dirty pages in the buffer pool to the REDO logs
考题
单选题You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）A
recycle buffer cacheB
large poolC
streams poolD
keep buffer cacheE
redo log buffer
考题
单选题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.
考题
多选题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
考题
单选题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 statement is true about FLUSH LOGS command?（）A
It requires the RELOAD, FILE, and DROP privilegesB
It closes and reopens all log filesC
It closes and sends binary log files to slave serversD
It flushes dirty pages in the buffer pool to the REDO logs
考题
多选题Which statements are true about checkpointing（）AThe checkpoint frequency decreases with the smaller redo log file size.BIt ensures that all committed data is written to the data files during normal shutdown.CThe frequent full checkpoint in a database can cause the overall degradation of the database performance.DIt prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the onlineredo log files
考题
单选题Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）A
SMON would automatically restore the lost file.B
You would need to restore the whole database from the last backup.C
You would need to restore the file from the last full database backup.D
You would need to use flashback technology to restore the lost redo log member.E
You would need to use Recovery Manager （RMAN） to restore the lost redo log member.F
You would need to restore the missing log file by copying one of the remaining files from the same group.
考题
单选题Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）A
DBWnB
RECOC
RVWRD
LGWR
考题
多选题Which two statements are true about checkpointing（）AThe checkpoint frequency decreases with the smaller redo log file size.BIt ensures that all committed data is written to the data files during normal shutdown.CThe frequent full checkpoint in a database can cause the overall degradation of the database performance.DIt prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.
考题
单选题Which component of the SGA stores parsed SQL statements is used for process sharing?（）A
Buffer cache B
Redo log buffer C
Private SQL area D
Library cache E
Row cache
考题
单选题Which background process is responsible for writing the dirty buffers from the write list to the data files during a checkpoint？（）A
CKPTB
SMONC
LGWRD
DBWnE
ARCn
考题
单选题Which background process reads the redo log buffer and writes it to a file？（）A
ARCnB
DBWnC
CKPTD
LGWRE
PMONF
SMON
考题
多选题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
热门标签
最新试卷