Multiple choice technology databases

Once defined, how long will a variable remain defined in SQL*Plus?

  1. Until the database is shut down

  2. Until the instance is shut down

  3. Until the statement completes

  4. Until the session completes
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In SQL*Plus, user-defined variables (created via DEFINE or ACCEPT) persist for the duration of the current SQL*Plus session. They are cleared only when explicitly undefined or when the session completes (exits).

Keep practicing — related questions