1Z0-182 practice question 2 of 15

You want to view the initialization parameter settings for only a specific PDB. Which of the following statements is true?

Full set: 94 questions

Answer options

A: From the PDB, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfile$;

B: From the CDB root, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;

C: From the CDB root, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfiles;

D: From the PDB, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter; Correct answer

Correct Answer:

D. From the PDB, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;

Explanation

To view the current and effective initialization parameter settings for a specific Pluggable Database (PDB), you must connect to that PDB and query the V$PARAMETER view. This dynamic performance view is container-aware; when queried from within a PDB, it displays the parameter values that are specifically in effect for that container. The ISPDBMODIFIABLE column indicates whether the parameter can be altered at the PDB level. This is the standard and correct method for inspecting a PDB's active parameter configuration.

Why Incorrect

A. pdbspfile$ is an internal, undocumented view related to stored SPFILE settings, not the current effective values, and should not be queried directly.
B. Querying v$parameter from the CDB root shows the settings for the root container, not the specific effective values for a particular PDB.
C. pdbspfiles is not a valid view name. The internal view is pdbspfile$, which should not be used for this purpose.

References

1. Oracle Database 23ai, "Database Reference", Chapter 4, "Dynamic Performance (V$) Views", Section "V$PARAMETER". (Documents that V$PARAMETER shows parameter values for the current session and is container-specific).

2. Oracle Database 23ai, "Multitenant Administrator's Guide", Chapter 5, "Administering PDBs", Section "Modifying Initialization Parameters for a PDB". (Describes using ALTER SYSTEM SET ... SCOPE=... within a PDB and verifying with SHOW PARAMETER or querying V$PARAMETER).

Keep practicing

Take the free 1Z0-182 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test