Oracle

1Z0-082 · Question #58

Which two statements are true about the SET VERIFY ON command? (Choose two.)

The correct answer is A. It can be used only in SQL*Plus D. It displays values for variables created by the DEFINE command. See the full explanation below for the reasoning.

SQL and PL/SQL

Question

Which two statements are true about the SET VERIFY ON command? (Choose two.)

Options

AIt can be used only in SQL*Plus
BIt displays values for variables used only in the WHERE clause of a query
CIt can be used in SQL Developer and SQL*Plus
DIt displays values for variables created by the DEFINE command
EIt displays values for variables prefixed with &&

How the community answered

(45 responses)

A
82% (37)
B
2% (1)
C
11% (5)
E
4% (2)

Topics

#SET VERIFY#SQL*Plus#substitution variables#DEFINE command

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-082 Practice