Which three statements regarding the server parameter file (SPFILE) are true? (Choose
three.)
A.
An SPFILE must be created manually, before creating a database, even if you use the
Database Configuration Assistant (DBCA) to create the database
B.
An SPFILE is a binary file
C.
An SPFILE cannot reside on a client
D.
An SPFILE cannot contain static parameters
E.
An SPFILE can store changes persistently across instance restarts
F.
An SPFILE can be read by the database server, but it is not written to by the server
B,C,E
http://docs.oracle.com/cd/E25178_01/server.1111/e25789/startup.htm#CNCPT89055
A server parameter file is a repository for initialization parameters that is managed by Oracle Database. A server parameter file has the following key characteristics:
Only one server parameter file exists for a database. This file must reside on the database host.
The server parameter file is written to and read by only by Oracle Database, not by client applications.
The server parameter file is binary and cannot be modified by a text editor.
Initialization parameters stored in the server parameter file are persistent. Any changes made to the parameters while a database instance is running can persist across instance shutdown and startup.
A server parameter file eliminates the need to maintain multiple text initialization parameter files for client applications. A server parameter file is initially built from a text initialization parameter file using the CREATE SPFILE statement. It can also be created directly by the Database Configuration Assistant.