Managing Archived Redo Logs MCQs
Managing Archived Redo Logs MCQs
Answer these Managing Archived Redo Logs MCQs and assess your grip on the subject of Managing Archived Redo Logs.
Scroll below and get started!
1: The LOG_ARCHIVE_DEST_STATE_n initialization parameter lets you control the availability state of the specified destination (n) in which status DEFER indicates?
A. Indicates that the destination is an alternate
B. All
C. Indicates that the location is temporarily disabled
D. Indicates that the database can use the destination
2: Which transmission involves transmitting files ta a local disk?
A. None
B. Normal transmission
C. Standby transmission And Normal transmission
D. Standby transmission
3: Which parameter uses all MANDATORY destinations plus some number of non-standby OPTIONAL destinations to determine whether LGWR can overwrite the online log?
A. LOG_ARCHIVE_MIN_SUCCEED_DEST=n
B. LOG_ARCHIVE_DEST_n And LOG_ARCHIVE_MIN_SUCCEED_DEST=n
C. None
D. LOG_ARCHIVE_DEST_n
4: In Dynamic Performance view which shows if the database is in ARCHIVELOG or NOARCHIVELOG mode and if MANUAL (archiving mode) has been specified?
A. V$ARCHIVE_DEST
B. V$ARCHIEVE_PROCESSES
C. V$ARCHIVED_LOG
D. V$DATABASE
5: Controlling Trace Output Generated by the Archivelog Process in which trace value 64 is?
A. Tracks asynchronous LGWR activity
B. Supported in a future release
C. Track FAL (fetch archived log) server related activities
D. Track ARCn process state activity
6:
In the Archive Log List Command which displays below tells you all the necessary information regarding the archived redo log settings for the current instance?
SQL> ARCHIVE LOG LIST
Database log mode Archive Mode
Automatic archival Enabled
Archive destination \oracle\oradata\IDDB2\archive
Oldest online log sequence 11160
Next log sequence to archive 11163
Current log sequence 11163
A.
The database is currently operating in NOARCHIVELOG mode
B.
Automatic archiving is disabled
C.
None
D.
The current redo log file has a sequence number of 11160
7: In Specifying the Mode of Log Transmission which modes of transmitting archived logs to their destination are?
A. Normal archiving transmission And Standby transmission
B. None
C. Normal archiving transmission
D. Standby transmission
8: Which parameter is used to specify a maximum of two locations,used to specify a primary archive destination?
A. LOG_ARCHIVE_FORMAT
B. LOG_ARCHIVE_DUPLEX_DEST
C. None
D. LOG_ARCHIVE_DEST
9: The SQL*Plus command ARCHIVE LOG LIST displays archiving information for the connected instance?
A. True
B. False
10: In Archive Destination Status which indicates whether there was a problem accessing the destination?
A. Valid/Invalid
B. Enabled/Disabled
C. All
D. Active/Inactive
List of Managing Archived Redo...
Available in:
Managing Archived Redo Logs MCQs
