Exam 1z0-062 topic 1 question 40 discussion

Actual exam question from Oracle's 1z0-062

Question #: 40
Topic #: 1

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

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 the 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 the SGA_TARGET and MEMORY_TARGET parameters are set.
D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

Show Suggested Answer

Suggested Answer: B 🗳️
Example:

SQL> startup force -
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings
ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET

by _Cobra_ at May 8, 2022, 8:42 a.m.

Comments

Submit Cancel

_Cobra_

3 years, 1 month ago

B IS CORRECT

upvoted 1 times

_Cobra_

3 years, 1 month ago

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/STATISTICS_LEVEL.html#:~:text=STATISTICS_LEVEL%20specifies%20the%20level%20of%20collection%20for%20database,a%20variety%20of%20purposes%2C%20including%20making%20self-management%20decisions.?msclkid=ba84e1c4ceaa11ec8f34e3541b7ab01e

upvoted 1 times

...