Oracle
1Z0-071 · Question #318
Examine this query: Which two methods should you use to prevent prompting for a hire date value when this query is executed? (Choose two.)
The correct answer is B. Use the DEFINE command before executing the query. E. Store the query in a script and pass the substitution value to the script when executing it. See the full explanation below for the reasoning.
Question
Examine this query:
Which two methods should you use to prevent prompting for a hire date value when this query is executed? (Choose two.)
Options
- AReplace
&1' with&&1' in the query. - BUse the DEFINE command before executing the query.
- CUse the UNDEFINE command before executing the query.
- DExecute the SET VERIFY ON command before executing the query.
- EStore the query in a script and pass the substitution value to the script when executing it.
- FExecute the SET VERIFY OFF command before executing the query.
How the community answered
(37 responses)- A3% (1)
- B78% (29)
- C11% (4)
- D5% (2)
- F3% (1)
Community Discussion
No community discussion yet for this question.