Oracle
1Z0-043 · Question #81
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below: SGA_TARGET= 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two…
The correct answer is B. The value for SGA_TARGET can be increased up to a maximum of 14 GB. E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated. See the full explanation below for the reasoning.
Question
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below:
SGA_TARGET= 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario? (Choose two.)
Options
- AA maximum of 3 GB can be allocated to shared pool.
- BThe value for SGA_TARGET can be increased up to a maximum of 14 GB.
- CA total of 14 GB memory will be allocated to the automatically tuned memory components.
- DIncreasing the value for SGA_TARGET will automatically increase the memory allocated for
- EIncreasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated
- FReducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to
How the community answered
(40 responses)- A3% (1)
- B83% (33)
- C3% (1)
- D8% (3)
- F5% (2)
Community Discussion
No community discussion yet for this question.