OCP CBT Question 669

Please solve the following question.

You are managing an Oracle database instance. You execute the following command: `ALTER SYSTEM SET PGA_AGGREGATE_TARGET = 1G SCOPE = SPFILE;` What is the effect of this command?

The PGA_AGGREGATE_TARGET parameter is immediately changed to 1GB for the current instance and also updated in the SPFILE.

The PGA_AGGREGATE_TARGET parameter is updated in the SPFILE, but the change will only take effect after the database instance is restarted.

The PGA_AGGREGATE_TARGET parameter is immediately changed to 1GB for the current instance only.

The command results in an error because PGA_AGGREGATE_TARGET is a static parameter and cannot be changed.