Oracle-12c OCP认证062考试题库解析-第40题

时间：2019-07-16 来源：

2018年的时候，OCP 11g考试题库大更新，052 053出现了很多新题，

2019年，11g即将停考的前期，Oracle又出现了一次大变动，12c出现了很多新题，比如062 063题库大更新

OCP解析公开课时间：【每周五晚8点】

OCP解析公开课地址：https://ke.qq.com/course/326223

OCP解析群资料分享：1015267481 验证：ocp

-------------------------------------------------------

QUESTION 40

To implement Automatic Management (AMM), you set t he following parameters:

MEMORY_MAX_TARGET=600M

SGA_MAX_SIZE=500M

MEMORY_TARGET=600M

OPEN_CURSORS=300

PROCESSES=150

STATISTICS_LEVEL=BASIC

PGA_AGGREGATE_TARGET=0

When you try to start the database instance with these parameter settings, you receive the following error message:

SQL > startup

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.

Identify the reason t he instance failed to start.

A . The PGA_AGGREGATE_TARGET parameter is set to zero.

B. The STATISTICS_LEVEL parameter is set to BASIC.

C. Both t he SGA_TARGET and MEMORY_TARGET parameters are set.

D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

Correct Answer: B