Technology Exchange
免费咨询热线
400-090-9964
2018年的时候,OCP 11g考试题库大更新,052 053出现了很多新题,
2019年,11g即将停考的前期,Oracle又出现了一次大变动,12c出现了很多新题,比如062 063题库大更新
OCP解析公开课时间:【每周五晚8点】
OCP解析公开课地址:https://ke.qq.com/course/326223
OCP解析群资料分享:1015267481 验证:ocp
-------------------------------------------------------
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都修改。)