nerdexam
Oracle

1Z0-074 · Question #97

Examine these parameters in a PFILE used to start database instance. Which two statements are true after an instance restart is attempted and why? (Choose two.)

The correct answer is C. The MEMORY_MAX_TARGET parameter is set to zero for the instance. D. MEMORY_MAX_TARGET is automatically set to 4G for the instance. Explanation/Reference:

Administering a Multitenant Container Database

Question

Examine these parameters in a PFILE used to start database instance. Which two statements are true after an instance restart is attempted and why? (Choose two.)

Exhibit

1Z0-074 question #97 exhibit

Options

  • APGA_AGGREGATE_TARGET and SGA_TARGET remain 1G and 2G respectively.
  • BPGA_AGGREGATE_TARGET and SGA_TARGET are set to zero for the instance.
  • CThe MEMORY_MAX_TARGET parameter is set to zero for the instance.
  • DMEMORY_MAX_TARGET is automatically set to 4G for the instance.
  • EThe instance does not start because AMM is enabled but PGA_AGGREGATE_TARGET and

How the community answered

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

Explanation

Explanation/Reference:

Topics

#AMM#MEMORY_MAX_TARGET#PGA_AGGREGATE_TARGET#SGA_TARGET

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice