Examine this query:Which two methods should you use to prevent prompting for a hire date value when this query is execut
Posted: Sun Jun 11, 2023 3:54 pm
Examine this query:Which two methods should you use to prevent prompting for a hire date value when this query is executed? (Choose two.)
A. Use the DEFINE command before executing the query.
B. Replace '&1' with '&&1' in the query.
C. Use the UNDEFINE command before executing the query.
D. Execute the SET VERIFY OFF command before executing the query. E. Execute the SET VERIFY ON command before executing the query. F. Store the query in a script and pass the substitution value to the script when executing it.
- Examine This Qu 1 (20.79 KiB) Viewed 291 times
B. Replace '&1' with '&&1' in the query.
C. Use the UNDEFINE command before executing the query.
D. Execute the SET VERIFY OFF command before executing the query. E. Execute the SET VERIFY ON command before executing the query. F. Store the query in a script and pass the substitution value to the script when executing it.