> > Oracle MCQs > Managing Archived Redo Logs MCQs

Managing Archived Redo Logs MCQ

In Archive Destination Status which indicates whether there was a problem accessing the destination?

Valid/Invalid

Enabled/Disabled

All

Active/Inactive

Answer

Correct Answer: Active/Inactive

Note: This Question is unanswered, help us to find answer for this one

The SQL*Plus command ARCHIVE LOG LIST displays archiving information for the connected instance?

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

Which parameter is used to specify a maximum of two locations,used to specify a primary archive destination?

LOG_ARCHIVE_FORMAT

LOG_ARCHIVE_DUPLEX_DEST

None

LOG_ARCHIVE_DEST

Answer

Correct Answer: LOG_ARCHIVE_DEST

Note: This Question is unanswered, help us to find answer for this one

In Specifying the Mode of Log Transmission which modes of transmitting archived logs to their destination are?

Normal archiving transmission And Standby transmission

None

Normal archiving transmission

Standby transmission

Answer

Correct Answer: Normal archiving transmission And Standby transmission

Note: This Question is unanswered, help us to find answer for this one

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

The database is currently operating in NOARCHIVELOG mode

Automatic archiving is disabled

None

The current redo log file has a sequence number of 11160

Answer

Correct Answer:

None

Note: This Question is unanswered, help us to find answer for this one

Controlling Trace Output Generated by the Archivelog Process in which trace value 64 is?

Tracks asynchronous LGWR activity

Supported in a future release

Track FAL (fetch archived log) server related activities

Track ARCn process state activity

Answer

Correct Answer: Track ARCn process state activity

Note: This Question is unanswered, help us to find answer for this one

In Dynamic Performance view which shows if the database is in ARCHIVELOG or NOARCHIVELOG mode and if MANUAL (archiving mode) has been specified?

V$ARCHIVE_DEST

V$ARCHIEVE_PROCESSES

V$ARCHIVED_LOG

V$DATABASE

Answer

Correct Answer: V$DATABASE

Note: This Question is unanswered, help us to find answer for this one

Which parameter uses all MANDATORY destinations plus some number of non-standby OPTIONAL destinations to determine whether LGWR can overwrite the online log?

LOG_ARCHIVE_MIN_SUCCEED_DEST=n

LOG_ARCHIVE_DEST_n And LOG_ARCHIVE_MIN_SUCCEED_DEST=n

None

LOG_ARCHIVE_DEST_n

Answer

Correct Answer: LOG_ARCHIVE_MIN_SUCCEED_DEST=n

Note: This Question is unanswered, help us to find answer for this one

Which transmission involves transmitting files ta a local disk?

None

Normal transmission

Standby transmission And Normal transmission

Standby transmission

Answer

Correct Answer: Normal transmission

Note: This Question is unanswered, help us to find answer for this one

The LOG_ARCHIVE_DEST_STATE_n initialization parameter lets you control the availability state of the specified destination (n) in which status DEFER indicates?

Indicates that the destination is an alternate

All

Indicates that the location is temporarily disabled

Indicates that the database can use the destination

Answer

Correct Answer: Indicates that the location is temporarily disabled

Note: This Question is unanswered, help us to find answer for this one