Oracle
1Z0-054 · Question #101
1Z0-054 Question #101: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #101. The question stem and answer options stay visible for context.
Question
You are asked to implement Automatic Memory Management (AMM) and you added two initialization parameters to do this. The following are the some of the parameter settings: MEMORY_MAX_TARGET=600M SGA_MAX_SIZE=500M MEMORY_TARGET=600M OPEN_CURSORS=300 SGA_TARGET=300M PROCESSES=150 STATASTICS_LEVEL=BASIC PGA_AGGREGATE_TARGET=0 When you tried to start the database instance with these parameter settings, 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 You modified the parameter settings as shown below and the database instance started successfully. MEMORY_MAX_TARGET=600M SGA_MAX_SIZE=400M MEMORY_TARGET=550M OPEN_CURSORS=400 SGA_TARGET=300M PROCESSES=200 STATASTICS_LEVEL=TYPICAL PGA_AGGREGATE_TARGET=100M Analyze the parameter settings and identify why the instance failed to start the first time?
Options
- Abecause the STATISTICS_LEVEL parameter was set to BASIC
- Bbecause the PGA_AGGREGATE_TARGET parameter was set to zero
- Cbecause both the SGA_TARGET and MEMORY_TARGET parameters were set
- Dbecause MEMORY_TARGET and MEMORY_MAX_TARGET parameters were equal
- Ebecause the PROCESSES parameter was set to a value less than the minimum required
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.