Oracle
1Z0-063 · Question #40
You set the following parameters in the parameter file and restart the database instance: NEMORY_MAX_TARGET=0 MEMORY__TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements are…
The correct answer is C. The value of the memory_max_target parameter remains zero for the database instance. E. The instance does not start up because Automatic Memory Management (AMM) is enabled but. See the full explanation below for the reasoning.
Question
You set the following parameters in the parameter file and restart the database instance: NEMORY_MAX_TARGET=0 MEMORY__TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements are true?
Options
- AThe memory_max_target parameter is automatically set to 500 MB.
- BThe pga_aggregate_target and sga_target parameters are automatically set to zero.
- CThe value of the memory_max_target parameter remains zero for the database instance.
- DThe lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and
- EThe instance does not start up because Automatic Memory Management (AMM) is enabled but
How the community answered
(40 responses)- A3% (1)
- B10% (4)
- C83% (33)
- D5% (2)
Community Discussion
No community discussion yet for this question.