nerdexam
Oracle

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.

Managing the Database Instance

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)
  • A
    88% (37)
  • B
    5% (2)
  • D
    5% (2)
  • E
    2% (1)

Why each option

This question tests knowledge of Oracle Server Parameter Files (SPFILEs) including their creation and default location.

AAn SPFILE can be created from a PFILE or from memory.Correct

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`.

BA PFILE can be used to start up a database instance even if an SPFILE exists.

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.

CAn SPFILE must reside in the ORACLE_HOME/dbs directory.Correct

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.

DAn SPFILE can be created only before a database instance is started.

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.

EAn SPFILE contains only those dynamic parameters that can be changed without having to restart the

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

#SPFILE#PFILE#database startup#initialization parameters

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice