nerdexam
Oracle

1Z0-052 · Question #187

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

The correct answer is C. The server parameter file (SPFILE) was used to start the instance. The query exhibit shows the SPFILE parameter with a non-null path value, confirming the instance was started using a server parameter file (SPFILE) rather than a text-based PFILE.

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

How the community answered

(32 responses)
  • A
    16% (5)
  • B
    3% (1)
  • C
    72% (23)
  • D
    9% (3)

Why each option

The query exhibit shows the SPFILE parameter with a non-null path value, confirming the instance was started using a server parameter file (SPFILE) rather than a text-based PFILE.

AThe SGA_TARGET is a static parameter.

SGA_TARGET is a dynamic parameter with ISSYS_MODIFIABLE = IMMEDIATE, meaning it can be changed without restarting the instance; it is not a static parameter.

BThe instance is started, but the database is not yet open.

If the instance were started but the database not yet open (MOUNT state), the query against V$PARAMETER would still return results, but mount state is determined from V$INSTANCE or V$DATABASE, not from the SPFILE parameter value.

CThe server parameter file (SPFILE) was used to start the instance.Correct

When the output of SHOW PARAMETER SPFILE or a query on V$PARAMETER displays a non-null, non-empty value for the spfile parameter, it definitively means the instance was started with an SPFILE. An SPFILE-started instance automatically persists changes made via ALTER SYSTEM to the binary parameter file, and the SPFILE path is visible in V$PARAMETER.

DThe SGA_TARGET parameter does not have any effect on the database instance until the SGA_MAX_SIZE

SGA_TARGET is fully effective when set; it controls Automatic Shared Memory Management (ASMM) by directing Oracle to automatically size SGA components within the SGA_MAX_SIZE boundary.

Concept tested: Identifying SPFILE usage via V$PARAMETER output

Source: https://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams252.htm

Topics

#SPFILE#parameter file#instance startup#V$PARAMETER

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice