Oracle 11G OCP 1Z0-052 119

LuiseDalian發表於2014-06-24

(119)View the Exhibit and examine the output of the query.

image

What do you infer from this?

A.The SGA_TARGET is a static parameter.

B.The instance is started, but the database is not yet open.

C.The server parameter file (SPFILE) was used to start the instance.

D.The  SGA_TARGET  parameter  does  not  have  any  effect  on  the  database  instance  until  the SGA_MAX_SIZE parameter is specified.

 

答案:(C)

解析:

V$SPPARAMETER顯示關於伺服器引數檔案的內容. 如果沒用使用spfile來啟動例項,則在檢視的每行的ISSPECIFIED列的值都為FALSE.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17013648/viewspace-1192221/,如需轉載,請註明出處,否則將追究法律責任。

相關文章