052-118

Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)
A.An SPFILE is a binary file.
B.An SPFILE cannot reside on a client.
C.An SPFILE cannot contain static parameters.
D.An SPFILE can store changes persistently across instance restarts.
E.An SPFILE can be read by the database server, but it is not written to by the server.
F.An SPFILE must be created manually, before creating a database, even if you use the Database Configuration Assistant (DBCA) to create the database.

　　spfile 是一个二进制文件，是属于服务器端，不是客户端。 spfile 可以包含有静态参数，也可以存储实例重新启动的参数的长久的变化，spfile 可以在服务器上读，也可以通过 alter system 或者 alter session 来写入服务器。 spfile 在 DBCA创建数据库时创建或者使用 create spfile 来创建。