Writes buffers to disk
Writes current redo log number to datafile headers
Writes redo log information to disk
Reads information into memory for users
第1题:
You work as a database administrator for Certkiller .com. Users in the Certkiller 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?()
第2题:
You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? ()
第3题:
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? ()
第4题:
Which two statements about the background process of the database writer are true()
第5题:
Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true? ()
第6题:
Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: ’D:///REDO01.LOG’ You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?()
第7题:
increase the size of the redo log buffer
increase the number of redo log groups
increase the number of log writer processes
increase the number of ARCn processes
change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
第8题:
SMON would automatically restore the lost file.
You would need to restore the whole database from the last backup.
You would need to restore the file from the last full database backup.
You would need to use flashback technology to restore the lost redo log member.
You would need to use Recovery Manager (RMAN) to restore the lost redo log member.
You would need to restore the missing log file by copying one of the remaining files from the same group.
第9题:
Shared pool
Control file
SGA
PGA
第10题:
The redo log file should belong to an active group.
The redo log file should belong to an inactive group.
The redo log file should belong to the current group.
The redo log file can be dropped only if all the transactions are stopped.
Before a redo log file is dropped, it should be deleted from the operating system (OS).
第11题:
ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3;
第12题:
the value of the UNDO_RETENTION initialization parameter
the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
the online redo log files size
the number of redo log members in a group
第13题:
You are maintaining your OLTP database in Oracle10g. While observing the performance of the database, you find that the log switch occurs more than once for every 20 minutes, affecting the database performance. Which factor is responsible for frequent log switches?()
第14题:
Because of hardware failure, you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file?()
第15题:
You have the following online redo log configuration: Group Member 1 ’/disk1/oradata/redo01a.log’ 2 ’/disk2/oradata/redo02a.log’ 3 ’/disk3/oradata/redo03a.log’ You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files?()
第16题:
Which background process reads the redo log buffer and writes it to a file?()
第17题:
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?()
第18题:
The backup RB3 and the current online redo log files
the backup RB2 and the archived redo log files after the log sequence number 15622
Backup R81 and the archived redo log hies after the log sequence number 12871
The backup RB3 and the archived redo log files after the log sequence number 16721
第19题:
The database will hang.
The database will be crashed.
The database will be shut down.
The LGWR process writes redo log entries to the other redo log member of the Group2 group
第20题:
V$LOG
V$LOGFILE
DBA_LOG_GROUPS
V$LOG_HISTORY
第21题:
Writes buffers to disk
Writes current redo log number to datafile headers
Writes redo log information to disk
Reads information into memory for users
第22题:
ARCn
DBWn
CKPT
LGWR
PMON
SMON
第23题:
Transactions are rolled back using redo log files.
Transactions are rolled forward using redo log files.
Transactions are rolled back using redo log files and archived log files.
Transactions are rolled forward using redo log files and rolled back using redo log files.
第24题:
A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure.
During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files.
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.
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.