Exam 1z0-071 Topic 10 Question 9 Discussion
Actual exam question for Oracle's 1z0-071 exam
Question #: 9
Topic #: 10
Question #: 9
Topic #: 10
Which two statements are true about the SET VERIFY ON command?
Suggested Answer: A,B Vote an answer
The SET VERIFY ON command is related to how SQL*Plus and SQL Developer display information about substitution variables:
* A. It displays values for variables created by the DEFINE command: When VERIFY is set to ON, SQL*Plus and SQL Developer will display the old and new values of a substitution variable when it is redefined using the DEFINE command or when a new value is provided for it during the session.
* B. It can be used in SQL Developer and SQL*Plus: While traditionally associated with SQL*Plus, the SET VERIFY command is also supported in SQL Developer, allowing you to control the display of substitution variable values in both environments.
References:
* Oracle SQL*Plus User's Guide and Reference, especially the section on the SET command and
* substitution variables.
* A. It displays values for variables created by the DEFINE command: When VERIFY is set to ON, SQL*Plus and SQL Developer will display the old and new values of a substitution variable when it is redefined using the DEFINE command or when a new value is provided for it during the session.
* B. It can be used in SQL Developer and SQL*Plus: While traditionally associated with SQL*Plus, the SET VERIFY command is also supported in SQL Developer, allowing you to control the display of substitution variable values in both environments.
References:
* Oracle SQL*Plus User's Guide and Reference, especially the section on the SET command and
* substitution variables.
by Levi at Jun 24, 2026, 12:22 PM
0
0
0
10
Comments
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.
Report Comment
Commenting
You can sign-up / login (it's free).