View the Exhibit and examine the output of the query. What do you infer from this?
A.
The instance is started, but the database is not yet open.
B.
The server parameter file (SPFILE) was used to start the instance.
C.
The SGA_TARGET is a static parameter.
D.
The SGA_TARGET parameter does not have any effect on the database instance until
the SGA_MAX_SIZE parameter is specified.
The exhibit should be as that on
http://www.aiopass4sure.com/oracle-exams/1z0-050-exam-questions/what-do-you-infer-from-the-exhibit-and-examine-the-output-of-the-query.html
I think this exhibit should be replaced by this
http://www.aiotestking.com/oracle/what-do-you-infer-from-the-exhibit-and-examine-the-output-of-the-query/
The exhibit is the wrong one it should be this one:
http://www.aiotestking.com/oracle/what-do-you-infer-from-the-exhibit-and-examine-the-output-of-the-query/
ANSWER B why?
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.