What is the outcome and why?

In your database:SGA_TARGET = 270MPGA_AGGREGATE_TARGET = 90MThe 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?

Question:

What is the outcome and why?

Options:

The execution fails because SGA_TARGET and PGA_AGGREGATE_TARGET are already configured

The execution is successful and automatic memory management is enabled

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

The execution fails because the MEMORY_MAX_TARGET parameter must be configured to 400M before configuring the MEMORY_TARGET parameter

Correct Answer

The Correct Answer for this Question is

The execution is successful and automatic memory management is enabled

You may also like...

Leave a Reply

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