Multiple choice technology databases

Which statement regarding the contents of the V$PARAMETER view is true?

  1. Displays only the list of default values

  2. Displays only the list of all basic parameters

  3. Displays the currently in effect parameter values

  4. Displays only the list of all advanced parameters

  5. Displays the list of all the parameter files of a database

  6. Displays the current contents of the server parameter file.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

V$PARAMETER displays the current parameter values actively in use by the Oracle instance, including modified values that differ from defaults. It shows the effective runtime values, not just defaults or file contents.

Keep practicing — related questions