Which two statements are true about initialization parameter files? (Choose two.)
A.
A lost or damaged SPFILE can be re-created by using the parameter values listed in the alert log.
B.
A PFILE must exist for an SPFILE to be created.
C.
The ALTER SYSTEM command cannot be used to change the value of any parameter if a database
instance has started using a PFILE.
D.
Both the SPFILE and PFILE must always reside on a file system accessible from the database host server.
E.
On startup, by default a database instance always first searches for an SPFILE, and if it does not find any,
searches for a PFILE.
After reading the choices again, I would suggest A and E. The wording of C is a bit tricky as it states “The ALTER SYSTEM command ‘CANNOT BE USED’ to change the value of any parameter if a database instance has started using a PFILE.” Then I realized ALTER SYSTEM command CAN BE USED to change the value of any parameter even if a database instance has started using a PFILE but it’s only in effect for the current instance. If my logic is correct, then C is wrong.