What is the outcome and why?

In your database:
SGA_TARGET = 270M
PGA_AGGREGATE_TARGET = 90M
The MEMORY_TARGET and MEMORY_MAX_TARGET parameters are currently not configured.
You execute the command:
ALTER SYSTEM SET MEMORY_TARGET = 400M;
What is the outcome and why?
A. The execution fails because SGA_TARGET and PGA_AGGREGATE_TARGET are already configured
B. The execution is successful and automatic memory management is enabled
C. The execution is successful but does not enable automatic memory management because the MEMORY_MAX_TARGET parameter must be configured to a value greater than MEMORY_TARGET
D. The execution fails because the MEMORY_MAX_TARGET parameter must be configured to 400M before configuring the MEMORY_TARGET parameter

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.