Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 5 of 50

Marks: +1, -0

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?

none, because no input required
both the substitution variables ''hiredate' and 'mgr_id'.
only hiredate'
only 'mgr_id'

Go to Question:

Prev Question

Next Question