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必须在创建数据库之前,即使你使用的数据库配置助手(DBCA)创建数据库之前来手动创建。
Answer: ABD
答案解析:
The server parameter file is a binary file that cannot be edited using a text editor. spfile是一个二进制文件,
是属于服务器端,不是客户端。spfile可以包含有静态参数,也可以存储实例重新启动的参数的长久的变化,
spfile可以在服务器上读,也可以通过alter system或者alter session来写入服务器。spfile在DBCA创建数据库时创建或者使用create spfile来创建。
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.)