Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG
mode. Which two statements regarding archive log destinations are true? (Choose two.)
A.
The destination must be global only.
B.
A maximum of five destinations can be assigned.
C.
A maximum of ten different destinations can be assigned.
D.
All the destinations are determined by the server automatically.
E.
The destination may be local or remote for a Standby Database.
F.
The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.
From 11g there are up to 31 destination can be set. Among those destination, archive destinations 1 to 10 are available for local or remote locations. Archive destinations 11 to 31 are available for remote locations only. So C is not very accurate. It should be maximum ten local destination can be set? Before 11g, there’s only 10 for LOG_ARCHIVE_DEST_n
https://docs.oracle.com/cd/E18283_01/server.112/e17120/archredo004.htm
Archiver Process (ARCn) – One or more archiver processes make copies of online redo logs either locally or remotely for standby databases.
LOG_ARCHIVE_FORMAT is applicable only if you are using the redo log in ARCHIVELOG mode. Use a text string and variables to specify the default filename format when archiving redo log files.
MAX TEN. STANDBY