Question 35

Question

You execute these commands:
SQL> DEFINE hiredate = ’01-APR -2011’;
SQL> SELECT employee_id, first_name, salary FROM employees WHERE hire date > &hiredate AND
manager_id >&mgr_id;
For which substitution variables will you be prompted?

Accepted Answer

only &mgr_id

KevinP · Answer

Not B here, only &mgr_id triggers a prompt since hiredate got set by DEFINE already. Saw this trick in another practice set.

Leo O. · Answer

D imo, official guide and Oracle SQL labs reinforce this substitution behavior.

SeanT · Answer

Its D, similar question came up in a practice test and only &mgr_id gets prompted since hiredate was already set with DEFINE.

Oracle 1Z0-071 Real Exam Questions [October 2026 Update] Quiz

You execute these commands: SQL> DEFINE hiredate = ’01-APR -2011’; SQL> SELECT employee_id, first_name, salary FROM employees WHERE hire date > &hiredate AND manager_id >&mgr_id; For which substitution variables will you be prompted?

Premium Access Includes