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 server parameter file (SPFILE) was used to start the instance.
C.
The SGA_TARGET parameter does not have any effect on the database instance until the SGA_MAX_SIZE parameter is specified.
D.
The instance is started, but the database is not yet open.
not able to understand this answer. can someone plz explain.
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.
https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2112.htm#REFRN30245
Because it queries v$spparameter view.