Which statement about a server parameter file (SPFILE) is false?
A.
An SPFILE is a binary file that cannot be edited by using a text editor.
B.
You can create an SPFILE from an existing text initialization parameter file or from memory.
C.
You can use the SHOW PARAMETERS command to display the values of initialization
parameters in an SPFILE.
D.
The instance first searches for an SPFILE named spfileoRACLE_SID.ora and, if this is not
found. It searches for spfile.ora.
D
Answer is C
because Statement C is false: “show parameter …” shows the current value of an initialization parameter in the instance, not the value from spfile!
D is the correct search order
C
D
SQL> show parameter spfile;
NAME TYPE VALUE
—- —- ———————————————————-
spfile string /root/apps/oracle/10g/dbs/spfile.ora
No values returned means its started by pfile.
http://docs.oracle.com/database/121/ADMIN/start.htm#ADMIN12825
Answer is C
C
http://docs.oracle.com/cd/B28359_01/server.111/b28310/create006.htm#ADMIN12345
Note:
Upon startup, the instance first searches for an SPFILE named spfileORACLE_SID.ora, and if not found, searches for spfile.ora. Using spfile.ora enables all Real Application Cluster (RAC) instances to use the same server parameter file.
If neither SPFILE is found, the instance searches for the text initialization parameter file initORACLE_SID.ora.
C
NOT D: SQL*Plus command SHOW PARAMETERS SPFILE (or any other method of querying the value of a parameter) displays the name of the server parameter file that is currently in use.
C: Upon startup, the instance first searches for an SPFILE named spfileORACLE_SID.ora, and if not found, searches for spfile.ora.