Oracle Exam 1Z0-071 Topic 3 Question 2 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 2
Topic #: 3

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?

Anone, because no input required

Bboth the substitution variables ''hiredate' and 'mgr_id'.

Conly hiredate'

Donly 'mgr_id'

Show Suggested Answer

Suggested Answer: D

by Viva at May 05, 2022, 12:04 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!