Prev Question
Next Question

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.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *