Multiple choice technology databases

In Oracle 10g , which statement regarding the contents of the V$PARAMETER view is true?

  1. Displays only the list of all default values.

  2. Displays only the list of all basic parameters.

  3. Displays currently in effect parameter values.

  4. Displays only the list of all advanced parameter.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

V$PARAMETER displays all parameter values currently in effect for the running instance, including both dynamic changes (ALTER SESSION/SYSTEM) and static parameters. This is different from V$PARAMETER2 (splits list values) or V$SYSTEM_PARAMETER (shows instance-level values). It shows actual effective values, not just defaults or basic/advanced classifications.

Keep practicing — related questions