You decided to increase the value for the SHARED_SERVERS parameter by using the following command: SQL> ALTER SYSTEM SET SHARED_SERVERS=3 SCOPE=?; Which three values can be specified for the SCOPE…

ALL is not a recognized value for the SCOPE clause in the ALTER SYSTEM command.

PFILE is a static text file (init.ora) that must be edited manually outside of SQL - it cannot be targeted by the SCOPE clause of ALTER SYSTEM.

BOTH writes the parameter change to the SPFILE and simultaneously applies it to the running instance memory, making it immediately effective and persistent across future restarts.

NONE is not a valid SCOPE clause value; every ALTER SYSTEM SET command that modifies a parameter must target MEMORY, SPFILE, or BOTH.

SPFILE writes the change only to the server parameter file without affecting the currently running instance, so the new value takes effect only after the next database restart.

MEMORY applies the change only to the current running instance in memory and does not update the SPFILE, so the change is lost when the database is restarted.

INSTANCE is not a valid value for the SCOPE clause; the equivalent in-memory option is MEMORY.

DATABASE is not a valid value for the SCOPE clause in ALTER SYSTEM.