You execute the following commands:
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’
which substitution variables are you prompted for the input?
You execute the following commands:
For which substitution variables are you prompted for the input?
It should be D.
Is B
I tried on ORACLE DB 12102.
The variable hiredate do not need to input again when use it in SQL command.
D is correct.
D
SQL>
SQL> define numero = 2;
SQL> select ‘&numero’ from dual;
‘2’
—
2
SQL>
D is correct
D
D