Which two statements are true about the SET VERIFY ON command? (Choose two.)
Which two statements are true about the SET VERIFY ON command? (Choose two.)
The SET VERIFY ON command in SQL*Plus displays the before and after substitution values for variables. It includes variables created by the DEFINE command and variables prefixed with double ampersands (&&). This ensures that users can see what values are substituted into a SQL statement before it is executed. While it is commonly used in SQL*Plus, it does not necessarily work the same way in SQL Developer, making statements about its usage in SQL Developer less reliable.
BDE are correct, when SET VERIFY ON it shows us variables defined by a DEFINE and a variables in &&.
I did the test and it also worked for me for answers B, D and E.
correct is BE
BDE all worked for me.
I did the test and it also worked for me for answers B, D and E.
I think it is just BE. If I make sure the variable is undefined before I use && then I don't get the new and old references in script output.
B no right: VERIFY ON shows all substituted variables althought you dont use DEFINE (sqlplus/developer ask for them).
BDE are true but if I have to narrow it down to 2 answers then DE.
BDE ---All true
Should be DE
BE for me
id say DE, B is kinda right?
correct is BE
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.
correct is BE
Is C also correct?