Explanation:
Destination is an Oracle Net alias specified by using the SERVICE keyword. Specify the archive destination by adding the following entry to the primary database init.ora file: LOG_ARCHIVE_DEST_2 = 'SERVICE=standby1 MANDATORY REOPEN=60' Incorrect Answer:
1: There is no limitation in Oracle regarding only two destinations per remote database.
3: It is not required to use the REOPEN attribute when using remote archive log file destination.
4: The service name is resolved by searching init.ora, not sqlnet.ora file for the remote database name.
Reference:
OCP Oracle 9i Database: Fundamentals II Exam Guide, Rama Velpuri, p. 61
Chapter 3: Basic Net Server-Side Configuration

---