Oracle Database Administration I — Question 25

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

Answer options

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

Correct answer: C, E

Explanation

The correct answer is C, as the SET VERIFY ON command can be utilized in both SQL Developer and SQL*Plus. Option E is also correct because it displays values for variables that are prefixed with &&. Options A and B are incorrect because they limit the command's usage and functionality, and D is incorrect as the command does not specifically relate to variables created by the DEFINE command.