Which two statements are true about a server parameter file (SPFILE)? (Choose two.)
A.
An SPFILE can be created from a PFILE or from memory.
B.
A PFILE can be used to start up a database instance even if an SPFILE exists.
C.
An SPFILE must reside in the ORACLE_HOME/dbs directory.
D.
An SPFILE can be created only before a database instance is started.
E.
An SPFILE contains only those dynamic parameters that can be changed without having to restart the
database instance.
The answer should be A,B
AB
I agree.
C is wrong. The SPFILE resides in the ORACLE_HOME/dbs directory; however, users can place it anywhere on their machine as long as it is specified in an initialization parameter file.
https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams204.htm#REFRN10207