✅ C. It can be used only in SQL*Plus.
True. SET VERIFY ON is a command specific to SQL*Plus (and tools that emulate it).
It is not supported in GUI tools like SQL Developer (though similar behavior can sometimes be simulated).
✅ D. It displays values for variables prefixed with &&.
True. When SET VERIFY ON is enabled, SQL*Plus displays the old and new values of substitution variables (like &&var) before executing the SQL.
❌ Incorrect options:
A. It displays values for variables used only in the WHERE clause of a query.
➤ False. It shows substituted values regardless of where they are used, not just in the WHERE clause.
B. It displays values for variables created by the DEFINE command.
➤ False. SET VERIFY ON shows values of substitution variables, not necessarily those created by DEFINE.
E. It can be used in SQL Developer and SQLPlus.*
➤ False. SET VERIFY ON works only in SQL*Plus. SQL Developer ignores it.
The SET VERIFY command controls whether or not SQLPlus displays before and after images of each line that contains a substitution variable1. The correct answers to your question are B and E. The SET VERIFY ON command will enable the display of any substitution variable used in our last executed SQL statement. When you use the DEFINE clause to create a variable, and the variable is not used in the next SQL statement then that variable will not be “shown” by the SET VERIFY command2. It can be used in both SQL Developer and SQLPlus.
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
826cb95
2 weeks, 4 days agohighwater
1 month agomaksud020
5 months agoacd3ea6
7 months, 2 weeks agohighwater
1 month agoShahedOdeh
7 months, 2 weeks agoArslanAltaf
1 year agohmatinnn
1 year, 3 months agoyaya32
1 year, 3 months agoyanoolthecool
1 year, 4 months agojm9999
1 year, 7 months agojm9999
1 year, 6 months agoKizTine
1 year, 6 months agozouve
1 year, 10 months agozouve
1 year, 10 months agozouve
1 year, 10 months agoESZ
1 year, 11 months agoSantiBZ_07032022_1744
2 years, 3 months agoholdfaststrongly
2 years, 7 months agokarols32
2 years, 7 months agoKizTine
1 year, 6 months agoAveragenoob
2 years, 7 months ago