nerdexam
Oracle

1Z0-052 · Question #187

View the Exhibit and examine the output of the query. What do you infer from this?

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

Managing the Database Instance

Question

View the Exhibit and examine the output of the query. What do you infer from this?

Exhibit

1Z0-052 question #187 exhibit

Options

  • AThe SGA_TARGET is a static parameter.
  • BThe instance is started, but the database is not yet open.
  • CThe server parameter file (SPFILE) was used to start the instance.
  • DThe SGA_TARGET parameter does not have any effect on the database instance until the SGA_MAX_SIZE

Unlock 1Z0-052 to see the answer

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

Topics

#SPFILE#parameter file#instance startup#V$PARAMETER
Full 1Z0-052 Practice