Managing The Redo Log MCQs
Managing The Redo Log MCQs
The following Managing The Redo Log MCQs have been compiled by our experts through research, in order to test your knowledge of the subject of Managing The Redo Log. We encourage you to answer these multiple-choice questions to assess your proficiency.
Please continue by scrolling down.
1: If the ARCHIVE_LAG_TARGET initialization parameter is set to a very low value, there can be which impact on performance?
A. All
B. Positive
C. None
D. Negative
2: Which log shows the following statement? ALTER SYSTEM SWITCH LOGFILE;
A. Drops Redo log member
B. Forces a log switch
C. None
D. Drops Redo log group
3: Which of these statements overcomes two situations where dropping redo logs is not possible?
A. The corrupt redo log file belongs to the Inactive group
B. If there are only two log groups
C. The corrupt redo log file belongs to the current group
D. If there are only two log groups And The corrupt redo log file belongs to the current group
4: A log switch is the point at which the database starts writing to one redo log file and begins writing to another?
A. False
B. True
5: Redo log files that are no longer required for instance recovery are called?
A. None
B. Active Redo log files
C. Inactive Redo log files
D. Current
6: The minimum size permitted for a redo log file is?
A. 4 MB
B. 16 MB
C. 6 MB
D. 8 MB
7: In Redo Log Information which view Identifies redo log groups and members and member status?
A. V$LOG
B. None
C. V$LOGFILE
D. V$LOG_HISTORY
8: Which mode protects a database from instance failure but not from media failure?
A. ARCHIVELOG MODE
B. NOARCHIVELOG MODE
C. ARCHIVELOG MODE And NOARCHIVELOG MODE
D. None
9: When speaking in the context of multiple database instances, the redo log for each database instance is also referred to as a?
A. All
B. Redo record
C. Redo entry
D. Redo thread
10: In which parameter used in the CREATE DATABASE statement determines the maximum number of groups of redo log files for each database?
A. Default
B. MAXLOGMEMBERS
C. MAXLOGFILES
D. None
List of Managing The Redo Log ...
Available in:
Managing The Redo Log MCQs
