47題、choose one

Your database instance is started with a PFILE.

Examine the parameters:

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?

A) The value is changed for the current instance and in the PFILE.

B) It fails because the SCOPE clause is missing.

C) The value is changed only in the PFILE and takes effect at the next instance startup.

D) Change is applied to the current instance, but does not persist after instance restart.

Answer：A

(解析：這個參數(shù)是動態(tài)參數(shù)，默認(rèn)是當(dāng)前實(shí)例和spfile都修改。)

071題庫

http://www.youjipx.com/071kaoshitiku/

http://www.youjitrain.com/071tiku/

http://www.ujpeixun.com/071kaoshi/

http://www.fh-soft.com/071tiku/

http://www.firstyuding.com/071tiku/

http://www.fljsyy.com/071tiku/

http://www.fuhua-pet.com/071tiku/

http://www.gbaiyou.com/071tiku/

http://www.gth163.com/071tiku/

http://www.gwwp168.com/071tiku/

http://www.gzslhs.com/071tiku/

http://www.hcjggs.com/071tiku/

http://www.hlflowers.com/071tiku/