Oracle Database SQL — Question 266

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

Answer options

• A. It displays values for variables used only in the WHERE clause of a query.
• B. It displays values for variables created by the DEFINE command.
• C. It can be used only in SQL*Plus.
• D. It displays values for variables prefixed with &&.
• E. It can be used in SQL Developer and SQL*Plus.

Correct answer: B, E

Explanation

The correct answers are B and E because the SET VERIFY ON command reveals values for variables defined with the DEFINE command and can be utilized in both SQL Developer and SQL*Plus. Option A is incorrect as it does not limit the display to just the WHERE clause, and option C is wrong since it is not restricted to SQL*Plus alone.