Multiple choice

Which of the following statements about the use of the LOG_ARCHIVE_DEST_n initialization parameters is true?

  1. When defining multiple archive destinations, at least one LOCATION parameter must be included.

  2. The maximum number of remote archive destinations is ten.

  3. Archive destinations may only be modified at the system level.

  4. Possible archive destinations include the local disk, any remote database, or a remote standby database.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When defining multiple LOG_ARCHIVE_DEST_n destinations, at least one must be a local disk destination (mandatory for the primary database). The maximum is 10 or 31 depending on Oracle version, not specifically 10. Destinations can be modified at both system and session level. Options include local disk and remote standby databases, but not arbitrary remote databases without Data Guard.

Keep practicing — related questions