Oracle

1Z0-071 · Question #343

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

The correct answer is A. It can be used in SQL Developer and SQL*Plus E. It displays values for variables created by the DEFINE command. https://blogs.oracle.com/opal/sqlplus-101-substitution-variables#4_1_8

Retrieving Data Using the SQL SELECT Statement

Question

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

Options

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

How the community answered

(46 responses)

A
74% (34)
B
15% (7)
C
4% (2)
D
7% (3)

Explanation

https://blogs.oracle.com/opal/sqlplus-101-substitution-variables#4_1_8

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-071 Practice