Which two methods should you use to prevent prompting for a hire date value when this query is executed?

Examine this query:

Which two methods should you use to prevent prompting for a hire date value when this query is executed?
A. Replace ‘&1’ with ‘&&1’ in the query.
B. Use the DEFINE command before executing the query.
C. Use the UNDEFINE command before executing the query.
D. Execute the SET VERIFY ON command before executing the query.
E. Store the query in a script and pass the substitution value to the script when executing it.
F. Execute the SET VERIFY OFF command before executing the query.

Download Printable PDF. VALID exam to help you PASS.