Multiple choice technology databases

How to change SQL prompt name

  1. set sqlprompt “Ravi Kishore > “

  2. set prompt “Ravi Kishore > “

  3. set sql “Ravi Kishore > “

  4. set sqlpromt “Ravi Kishore > “

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In SQL*Plus, the command set sqlprompt is used to change the command prompt string. The distractors are invalid command names (set prompt is used for other prompt styles, while sql and sqlpromt are syntactically incorrect in SQL*Plus).