1Z0-052 · Question #155
Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)
The correct answer is A. An SPFILE is a binary file B. An SPFILE cannot reside on a client D. An SPFILE can store changes persistently across instance restarts. An Oracle SPFILE is a binary, server-side file that persists parameter changes across instance restarts and can be both read and written by the database server.
Question
Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)
Options
- AAn SPFILE is a binary file
- BAn SPFILE cannot reside on a client
- CAn SPFILE cannot contain static parameters
- DAn SPFILE can store changes persistently across instance restarts
- EAn SPFILE can be read by the database server, but it is not written to by the server
- FAn SPFILE must be created manually, before creating a database, even if you use the Database
How the community answered
(68 responses)- A87% (59)
- C1% (1)
- E7% (5)
- F4% (3)
Why each option
An Oracle SPFILE is a binary, server-side file that persists parameter changes across instance restarts and can be both read and written by the database server.
An SPFILE is stored in binary format and cannot be edited with a text editor, unlike a traditional PFILE (init.ora) which is a plain text file.
An SPFILE must reside on the database server because the server process directly reads and writes to it; it cannot be located on a client machine.
An SPFILE can contain static parameters; those parameters simply require a database restart for the change to take effect.
Changes made using ALTER SYSTEM SET with SCOPE=SPFILE or SCOPE=BOTH are written persistently into the SPFILE, surviving instance shutdowns and restarts.
The Oracle database server both reads and writes to the SPFILE - it writes changes when ALTER SYSTEM SET is issued with SCOPE=SPFILE or SCOPE=BOTH.
An SPFILE does not need to be created manually before database creation; it can be created from a PFILE using CREATE SPFILE, or the Database Configuration Assistant can create it during database setup.
Concept tested: Oracle SPFILE characteristics and behavior
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/creating-and-configuring-an-oracle-database.html
Topics
Community Discussion
No community discussion yet for this question.