Q: 16
Examine this query: SELECT employee_id, first_name, salary FROM employees WHERE hiredate > 61* Which two methods should yours to prevent prompting for hire date value when this queries executed?
Options
Discussion
Probably B and F. C is a trap, only passing a value to a script doesn't always prevent prompts unless DEFINE is used. Seen similar logic on other practice exams.
C and E maybe?
B/F? DEFINE sets it so you won’t get prompted and SET VERIFY OFF avoids those substitution prompts. I think both are needed depending on the exact behavior of SQL*Plus. Not totally certain, but makes sense from practice.
B and F. DEFINE sets the var beforehand, SET VERIFY OFF stops the prompt for substitution. Pretty sure that's how you suppress the annoying value input in SQL*Plus, unless there's some strange session setting.
Be respectful. No spam.