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.)

oracle ocp 052-118

相關文章