nerdexam
Oracle

1Z0-034 · Question #124

1Z0-034 Question #124: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-034 to reveal the answer and full explanation for question #124. The question stem and answer options stay visible for context.

Question

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?

Exhibit

1Z0-034 question #124 exhibit

Options

  • ABecause the PGA_AGGREGATE_TARGET parameter is not set
  • BBecause the STATISTICS_LEVEL parameter is set to BASIC
  • CBecause MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal
  • DBecause both the SGA_TARGET and MEMORY_TARGET parameters are set.

Unlock 1Z0-034 to see the answer

You've previewed enough free 1Z0-034 questions. Unlock 1Z0-034 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.

Full 1Z0-034 Practice