> > Oracle MCQs > Managing The Redo Log MCQs

Managing The Redo Log MCQ

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

Oracle MCQs | Topic-wise

MCQ on Basic Oracle	MCQ on Managing Archived Redo Logs
MCQ on Managing Clusters	MCQ on Managing Control Files
MCQ on Managing Data-files And Temp-files	MCQ on Managing Hash Clusters
MCQ on Managing Indexes	MCQ on Managing Oracle Database Processes
MCQ on Managing Oracle Distributed Transactions	MCQ on Managing Partitioned Tables And Indexes
MCQ on Managing Space For Schema Objects	MCQ on Managing Tables
MCQ on Managing Tablespaces	MCQ on Managing The Redo Log
MCQ on Managing The Undo Tablespace	MCQ on Managing Views, Sequences, And Synonyms
MCQ on Oracle Distributed Transactions Concepts	MCQ on Oracle WebLogic
General Oracle MCQs