Exam 1z0-082 topic 1 question 156 discussion

Actual exam question from Oracle's 1z0-082

Question #: 156
Topic #: 1

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. Store the query in a script and pass the substitution value to the script when executing it.
B. Execute the SET verify off 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. Replace '&1' with '&&1' in the query.
F. Use the define command before executing the query.

Show Suggested Answer

Suggested Answer: DF 🗳️

by Oracle2020 at April 14, 2024, 3:04 p.m.

Comments

Submit Cancel

cf1f99b

8 months ago

Selected Answer: AF

AF are the correct answers

upvoted 2 times

...

egznrd

1 year ago

AF Correct answers

upvoted 2 times

...

AF A-TRUE B-FALSE , has another function C False, not exist undefine command, only set define off D-False, set verify on will ensure the "old" and "new" lines appear when using a defined variable E False ,I have tried it and it asks to enter a value F-TRUE,if you use define to change the input parameter

upvoted 3 times

...