nerdexam
Oracle

1Z0-497 · Question #68

Which statement about a server parameter file (SPFILE) is false?

The correct answer is C. You can use the SHOW PARAMETERS command to display the values of initialization parameters. See the full explanation below for the reasoning.

Question

Which statement about a server parameter file (SPFILE) is false?

Options

  • AAn SPFILE is a binary file that cannot be edited by using a text editor.
  • BYou can create an SPFILE from an existing text initialization parameter file or from memory.
  • CYou can use the SHOW PARAMETERS command to display the values of initialization parameters
  • DThe instance first searches for an SPFILE named spfileoRACLE_SID.ora and, if this is not found.

How the community answered

(28 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    82% (23)
  • D
    11% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice