1Z0-062 · Question #291
Which two statements are true about a server parameter file (SPFILE)? (Choose two.)
The correct answer is A. An SPFILE can be created from a PFILE or from memory. C. An SPFILE must reside in the ORACLE_HOME/dbs directory. This question tests knowledge of Oracle Server Parameter Files (SPFILEs) including their creation and default location.
Question
Which two statements are true about a server parameter file (SPFILE)? (Choose two.)
Options
- AAn SPFILE can be created from a PFILE or from memory.
- BA PFILE can be used to start up a database instance even if an SPFILE exists.
- CAn SPFILE must reside in the ORACLE_HOME/dbs directory.
- DAn SPFILE can be created only before a database instance is started.
- EAn SPFILE contains only those dynamic parameters that can be changed without having to restart the
How the community answered
(42 responses)- A88% (37)
- B5% (2)
- D5% (2)
- E2% (1)
Why each option
This question tests knowledge of Oracle Server Parameter Files (SPFILEs) including their creation and default location.
An SPFILE is a binary file that can be created from a text-based initialization parameter file (PFILE) using `CREATE SPFILE FROM PFILE` or from the current memory parameters using `CREATE SPFILE FROM MEMORY`.
While a PFILE can be used to start a database instance, if an SPFILE exists, the database instance will prioritize and use the SPFILE by default unless a specific PFILE is explicitly specified during startup.
By default, Oracle expects the SPFILE to reside in the ORACLE_HOME/dbs directory on Linux/Unix or ORACLE_HOME/database on Windows, although its location can be specified during startup or implicitly found if in the default location.
An SPFILE can be created from a PFILE while the database is shut down or from memory while the database instance is running, not only before startup.
An SPFILE contains all initialization parameters, including both static and dynamic ones, not just dynamic parameters that can be changed without restarting the instance.
Concept tested: Oracle SPFILE creation and location
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-database-startup-and-shutdown.html#GUID-8EF924F0-A226-4740-A2BC-6B0C68C4307C
Topics
Community Discussion
No community discussion yet for this question.