You execute the following commands: For which substitution variables are you prompted for the input?

The correct answer is D. Only 'mgr_id'. SQL> define hiredate = ’01-APR-2011′ SQL> select employee_id, first_name, salary 2 from employees 3 where hire_date > ‘&hiredate’ 4 and manager_id > &mgr_id; old 3: where hire_date > ‘&hiredate’ new 3: where hire_date > ’01-APR-2011′ Enter value for mgr_id: 13 old 4: and…

Exadata Administration

Question

You execute the following commands:

For which substitution variables are you prompted for the input?

Exhibit

Options

ANone, because no input required
BBoth the substitution variables 'hiredate' and 'mgr_id\
COnly 'hiredate'
DOnly 'mgr_id'

How the community answered

(55 responses)

A
15% (8)
B
5% (3)
C
4% (2)
D
76% (42)

Explanation

SQL> define hiredate = ’01-APR-2011′ SQL> select employee_id, first_name, salary 2 from employees 3 where hire_date > ‘&hiredate’ 4 and manager_id > &mgr_id; old 3: where hire_date > ‘&hiredate’ new 3: where hire_date > ’01-APR-2011′ Enter value for mgr_id: 13 old 4: and manager_id > &mgr_id new 4: and manager_id > 13 no rows selected

Topics

#substitution variables#SQL*Plus#single ampersand#double ampersand

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice