119.View the Exhibit and examine the output of the query. What do you infer from this?

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

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
解析：
参考：http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3042.htm#REFRN30245
V$SPPARAMETER
V$SPPARAMETER displays information about the contents of the server parameter file. 
If a server parameter file was not used to start the instance, then each row of the view will contain FALSE in the ISSPECIFIED column.
NAME        VARCHAR2(80) Name of the parameter
VALUE        VARCHAR2(255) Parameter value (null if a server parameter file was not used to start the instance)
ISSPECIFIED  VARCHAR2(6)   Indicates whether the parameter was specified in the server parameter file (TRUE) or not (FALSE)