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
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)- A11% (3)
- B4% (1)
- C82% (23)
- E4% (1)
Explanation
Explanation/Reference:
Topics
#AMM#MEMORY_MAX_TARGET#PGA_AGGREGATE_TARGET#SGA_TARGET
Community Discussion
No community discussion yet for this question.
