OCP CBT Question 674

Please solve the following question.

You are managing an Oracle database configured for Automatic Memory Management (AMM). The `MEMORY_TARGET` parameter is set to 4GB, and `MEMORY_MAX_TARGET` is set to 8GB. The current `SGA_TARGET` is 3GB and `PGA_AGGREGATE_TARGET` is 1GB. Which statement is true if you try to increase `MEMORY_TARGET` to 6GB using `ALTER SYSTEM SET MEMORY_TARGET = 6G SCOPE = BOTH;`?

The command will succeed, and the new MEMORY_TARGET will take effect immediately.

The command will fail because MEMORY_TARGET cannot exceed SGA_TARGET + PGA_AGGREGATE_TARGET.

The command will fail because MEMORY_TARGET cannot exceed MEMORY_MAX_TARGET.

The command will succeed, but the change will only take effect after a database restart.