Prev Question
Next Question

You execute the following 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 are you prompted for the input?

A.
none, because no input required

B.
both the substitution variables ”hiredate’ and ‘mgr_id’.

C.
only hiredate’

D.
only ‘mgr_id’

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *