RelationalDBDesign
RelationalDBDesign
SiteMap
Architecture
DB Admin
Connect
Objects
Backup Recovery
Admin Tasks
Recovery File Structures
«Prev
Next»
Backup Recovery
Backup Considerations
Oracle Memory Processes
Oracle Recovery Data Structures
Archivelog Noarchivelog
Archiving Options
Archive log file - Quiz
1.
Which of the following statements is true about archive log files?
Please select
all the correct answers
.
A.
LGWR
is used to write archive log information.
B.
LOG_ARCHIVE_DUPLEX_DEST
is set in the init.ora file and indicates the secondary archive log location.
C.
Archive log files are copies of information from the redo log buffer.
D.
Archiving of redo log information can occur manually or automatically.
2.
CKPT coordinates the flushing of memory buffers to disk by which of the following processes?
Please select
the best answer
.
A.
DBWR
and
ARCH
B.
DBWR
and
LGWR
C.
DBWR
D.
LGWR
and
ARCH
3.
SCN is used during a checkpoint to synchronize which of the following data file(s)?
Please select
the best answer
.
A.
Redo log files, control files, data files, archive log files
B.
Redo log files, control files, data files
C.
Redo log files, control files
D.
Redo log files
4.
The parameter LOG_CHECKPOINT_TO_ALERT can be used for which purpose?
Please select
the best answer
.
A.
Indicate that there is a corrupt log file during checkpoint processing
B.
Identify which log file is currently being written to
C.
Determine if checkpoints are occurring often enough
D.
Updates the control file with the last checkpoint SCN