Your database instance is started with a PFILE.
NAME TYPE VALUE
Memory_max_target big integer 0
Memory_target big integer 0
Sga_max_size big integer 2G
Sga_target big integer 2G
You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
Which is the outcome? (Choose the best answer)
A.
Change is applied to the current instance, but does not persist after instance restart.
B.
The value is changed only in the PFILE and takes effect at the next instance startup.
C.
The value is changed for the current instance and in the PFILE.
D.
It fails because the SCOPE clause is missing.
Explanation:
A
If a server parameter file was used to start up the database, then BOTH is the default. If a parameter file was used to start up the database, then MEMORY is the default, as well as the only scope you can specify