（702）View the Exhibit and examine the parameter settings in your server-side parameter file(SPFILE).

When you tried to start the database instance,you received the following error:

SQL>startup

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings,

see alert log for more information

Why did the instance fail to start?

A. Because the PGA_AGGREGATE_TARGET parameter is not set

B. Because the STATISTICS_LEVEL parameter is set to BASIC

C. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal

D. Because both the SGA_TARGET and MEMORY_TARGET parameters are set.

答案：（B）

解析：

statistics_level控制数据库收集统计信息的级别，有三个参数值:

BASIC:收集基本的统计信息；

TYPICAL：收集大部分统计信息(数据库的默认设置)；

ALL：收集全部统计信息，如果设置为BASIC，则内存自动管理功能就不支持了，所以就报以上的错误。

其实可能还同时报错如下：ORA-00848:STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET

ITPub博客

Oracle 11G OCP 1Z0-053 702