Which three statements are true PFILEs, SPFILEs or both?

Which three statements are true PFILEs, SPFILEs or both? (Choose three.)
A. SPFILEs and PFILEs may both be edited with an O/S editing utility
B. Some SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause
C. A SPFILE can be created by an idle instance
D. A PFILE can be created by an idle instance
E. All SPFILE parameters can be modified successfully with the SCOPE=BOTH clause
F. All SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause

Download Printable PDF. VALID exam to help you PASS.

4 thoughts on “Which three statements are true PFILEs, SPFILEs or both?

  1. CDE is correct because
    E. All SPFILE parameters can be modified successfully with the SCOPE=BOTH clause -> is correct because you can modified but not apply until when restart using spfile

    1
    1
  2. C is not correct. The PFILE has to be created from the idle instance before an SPFILE can be created from the PFILE
    BDE is correct

    2
    2

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.