Oracle

1Z0-074 · Question #49

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

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

New Features for Manageability

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

(53 responses)

A
2% (1)
B
11% (6)
C
81% (43)
D
6% (3)

Explanation

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

Topics

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

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-074 Practice