nerdexam
Oracle

1Z0-063 · Question #157

Your database is running in archivelog mode. Examine the initialization parameters you plan to set for yourdatabase instance. LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 =…

The correct answer is A. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in. See the full explanation below for the reasoning.

Question

Your database is running in archivelog mode. Examine the initialization parameters you plan to set for yourdatabase instance. LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch' LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch' L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY' Identify the statement that correctly describes these settings.

Options

  • AAn online redo log file is not allowed to be overwritten if the archived log file cannot be created in
  • BOptional destinations cannot use the fast recovery area.
  • CAn online redo log file isnot allowed to be overwritten if the archived log file cannot be created in
  • DThese settings work only if log__archive_min_succeed_dest is set to a value of 4.

How the community answered

(20 responses)
  • A
    75% (15)
  • B
    5% (1)
  • C
    15% (3)
  • D
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice