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 parameter
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.
答案:ABD
解析:参考:http://docs.oracle.com/cd/E11882_01/server.112/e25494/create.htm#ADMIN11118
spfile是服务器端的二进制文件,包括静态和动态参数,可以通过server读和写,spfile会在DBCA上自动创建
A.An SPFILE is a binary file.
B.An SPFILE cannot reside on a client.
C.An SPFILE cannot contain static parameter
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.
答案:ABD
解析:参考:http://docs.oracle.com/cd/E11882_01/server.112/e25494/create.htm#ADMIN11118
spfile是服务器端的二进制文件,包括静态和动态参数,可以通过server读和写,spfile会在DBCA上自动创建