You switch from Automatic Memory Management (AMM) to Automatic Shared Memory Management (ASMM) by executing this statement: alter system set memory_target = 0; Next, you restart the instance and set these values: alter system set sga_max_size = 10gb; alter system set sga_target = 8gb; alter system set shared_pool_size = 1 gb; How do the values of SGA_TARGET, SGA_MAX_SIZE, and SHARED_POOL_SIZE vary throughout the day? (Choose the best answer.)

Answer: D

Explanation: When you enable ASMM by setting SGA_TARGET, the value does not change automatically and the SHARED_POOL_SIZE can grow and shrink as long as it does not fall below 1GB. A is incorrect because SGA_TARGET will not change dynamically; however, it can be changed by the DBA as long as it is less than the value of SGA_MAX_SIZE. B is incorrect because the value of SGA_TARGET does not change and has no effect on the PGA memory size since AMM is not enabled. C is incorrect because the value of SHARED_POOL_SIZE can vary above 1GB but is never lower than 1GB.