119.View the Exhibit and examine the output of the query.
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)
What do you infer from this?
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)