nerdexam
Oracle

1Z0-062 · Question #380

All of your database instances use SPFILES. You executed this command in one of them: ALTER SYSTEM SET MEMORY_MAX_TARGET=1024M; Which statement is true?

The correct answer is C. The parameter is modified in the parameter file only. https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN00207

Managing the Database Instance

Question

All of your database instances use SPFILES. You executed this command in one of them:

ALTER SYSTEM SET MEMORY_MAX_TARGET=1024M; Which statement is true?

Options

  • AThe parameter is modified in memory and in the parameter file.
  • BThe command returns an error.
  • CThe parameter is modified in the parameter file only.
  • DThe parameter is modified in memory only.

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    83% (20)
  • D
    8% (2)

Explanation

https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN00207

Topics

#SPFILE#ALTER SYSTEM#MEMORY_MAX_TARGET#parameter persistence

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice