The Instance Initialization parameters are set to:

The Instance Initialization parameters are set to:
DB_CREATE_FILE_DEST = +DATA
DB_CREATE_ONLlNE_LOG_DEST_l = +LOGS
DB_CREATE_ONLlNE_LOG_DEST_2 = + FRA
The SQL* Plus command ALTER DATABASE ADD LOGFILE; will create:

A.
a new log file in the +DATA disk group, or a log file in the + FRA disk group, if +DATA is not
available

B.
a new log file in the +DATA disk group and a log file in the + FRA disk group

C.
a new log file in the +LOGS disk group and a log file in the + FRA disk group

D.
a new log file in the +LOGS disk group, or a log file in the +FRA dls* available

E.
a new log file in the +DATA disk group, a log file in the +LOGS disk group, and a log file in the
+FRA disk group

F.
a new log file in the +LOGS disk group, or a log file in the +FRA disk group, if +LOGS is not
available

Explanation:
The following table lists the initialization parameters that enable the use of Oracle
Managed Files.
Initialization Parameter
DB_CREATE_FILE_DEST
Defines the location of the default file system directory or Oracle ASM disk group where the
database creates datafiles or tempfiles when no file specification is given in the create operation.
Also used as the default location for redo log and control files if
DB_CREATE_ONLINE_LOG_DEST_n are not specified.
DB_CREATE_ONLINE_LOG_DEST_n
Defines the location of the default file system directory or Oracle ASM disk group for redo log files
and control file creation when no file specification is given in the create operation. By changing n,
you can use this initialization parameter multiple times, where n specifies a multiplexed copy of the
redo log or control file. You can specify up to five multiplexed copies.
DB_RECOVERY_FILE_DEST
Defines the location of the Fast Recovery Area, which is the default file system directory or Oracle
ASM disk group where the database creates RMAN backups when no format option is used,
archived logs when no other local destination is configured, and flashback logs. Also used as the
default location for redo log and control files or multiplexed copies of redo log and control files if
DB_CREATE_ONLINE_LOG_DEST_n are not specified.
Oracle Database Administrator’s Guide