Examine the memory-related parameters set in the SPFILE of an Oracle database:
Which statement is true?
A.
Only SGA components are sized automatically.
B.
Memory is dynamically re-allocated between the SGA and PGA as needed.
C.
The size of the PGA cannot grow automatically beyond 500 MB.
D.
The value of the MEMORY_TARGET parameter cannot be changed dynamically.
Answer should be B