Which substitution variable would you use if you want to reuse the variable without prompting the user each time?

The correct answer is D. &&. To reuse the variable without prompting the user each time you can use && substitution variable. Incorrect Answers A: This substitution variable will prompt the user each time. B: ACCEPT is command, not substitution variable. It used to define more accurate or specific prompt…

Basic SQL SELECT Statements

Question

Options

A&
BACCEPT
CPROMPT
D&&

How the community answered

(41 responses)

A
7% (3)
B
17% (7)
C
2% (1)
D
73% (30)

Explanation

To reuse the variable without prompting the user each time you can use && substitution variable. Incorrect Answers A: This substitution variable will prompt the user each time. B: ACCEPT is command, not substitution variable. It used to define more accurate or specific prompt or when you want more output to display as the values are defined. C: PROMPT is part of the ACCEPT command, it is not a variable.

Topics

#substitution variables#double ampersand#variable reuse#iSQL*Plus

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice