nerdexam
Oracle

1Z0-082 · Question #135

Which two statements are true about substitution variables?

The correct answer is B. A substitution variable prefixed with to prompts only once for a value in a session unless it is set to. See the full explanation below for the reasoning.

SQL and PL/SQL

Question

Which two statements are true about substitution variables?

Options

  • AA substitution variable prefixed with & always prompts only once for a value in a session.
  • BA substitution variable prefixed with to prompts only once for a value in a session unless it is set to
  • CA substitution variable can be used only in a select statement.
  • DA substitution variable used to prompt for a column name must be enclosed in single quotation
  • EA substitution variable can be used with any clause in a select statement.
  • FA substitution variable used to prompt for a column name must be enclosed in double quotation

How the community answered

(62 responses)
  • A
    2% (1)
  • B
    73% (45)
  • D
    8% (5)
  • E
    15% (9)
  • F
    3% (2)

Topics

#substitution variables#& operator#&& operator#SQL*Plus scripting

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice