> > Oracle MCQs > Managing The Redo Log MCQs

Managing The Redo Log MCQ

In which parameter used in the CREATE DATABASE statement determines the maximum number of groups of redo log files for each database?

Default

MAXLOGMEMBERS

MAXLOGFILES

None

Answer

Correct Answer: MAXLOGFILES

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

When speaking in the context of multiple database instances, the redo log for each database instance is also referred to as a?

All

Redo record

Redo entry

Redo thread

Answer

Correct Answer: Redo thread

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

Which mode protects a database from instance failure but not from media failure?

ARCHIVELOG MODE

NOARCHIVELOG MODE

ARCHIVELOG MODE And NOARCHIVELOG MODE

None

Answer

Correct Answer: NOARCHIVELOG MODE

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

In Redo Log Information which view Identifies redo log groups and members and member status?

V$LOG

None

V$LOGFILE

V$LOG_HISTORY

Answer

Correct Answer: V$LOGFILE

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

The minimum size permitted for a redo log file is?

4 MB

16 MB

6 MB

8 MB

Answer

Correct Answer: 4 MB

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

Redo log files that are no longer required for instance recovery are called?

None

Active Redo log files

Inactive Redo log files

Current

Answer

Correct Answer: Inactive Redo log files

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

A log switch is the point at which the database starts writing to one redo log file and begins writing to another?

False

True

Answer

Correct Answer: False

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

Which of these statements overcomes two situations where dropping redo logs is not possible?

The corrupt redo log file belongs to the Inactive group

If there are only two log groups

The corrupt redo log file belongs to the current group

If there are only two log groups And The corrupt redo log file belongs to the current group

Answer

Correct Answer: If there are only two log groups And The corrupt redo log file belongs to the current group

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

Which log shows the following statement? ALTER SYSTEM SWITCH LOGFILE;

Drops Redo log member

Forces a log switch

None

Drops Redo log group

Answer

Correct Answer: Forces a log switch

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

If the ARCHIVE_LAG_TARGET initialization parameter is set to a very low value, there can be which impact on performance?

All

Positive

None

Negative

Answer

Correct Answer: Negative

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