ITPub博客

首页 > 数据库 > Oracle > 【第47题】【062题库】2019年OCP认证062考试新题

【第47题】【062题库】2019年OCP认证062考试新题

Oracle 作者:unix_5359 时间:2019-06-04 14:00:03 0 删除 编辑

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

(解析:这个参数是动态参数,默认是当前实例和spfile都修改。)


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31544987/viewspace-2646704/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
2018年,OCP考试题库经过一场大的变动, 2019年,OCP考试题库变动已经开始了,3月份更新了很多新题,不知道以后还会不会有大的更新。 OCP题库解析3:1015267481,新考题交流群

注册时间:2018-07-05

  • 博文量
    78
  • 访问量
    53170