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.
CE Do your RESearch please!
A is wrong,
first is create pfile by alert log , then create spfile by pfile.
https://docs.oracle.com/database/121/ADMIN/create.htm#ADMIN11123
E is absolutely correct , my opinion is D,E
This answer should be AE, not BE. Terrible… this test is hard enough already…
I agree with pG , the ans should be AE
yes, AE is correct
spfile can be recreate using alertlog:
https://docs.oracle.com/en/database/oracle/oracle-database/18/tutorial-recover-a-lost-or-damaged-server-parameter-file/index.html