select &&a col1, &&a col2 from dual;
select &&a col3 from dual;
D can't be answer , because it says " will prompt for a value once per query." but that is not the case.
AB is correct
https://docs.oracle.com/en/database/oracle/oracle-database/21/sqpug/using-substitution-variables-sqlplus.html#GUID-0BEEC1D7-876B-495C-9327-17037652D3D2
A.B correct.
reference for B
If a single ampersand prefix is used with an undefined variable, the value you enter at the prompt is not stored. Immediately after the value is substituted in the statement the variable is discarded and remains undefined. If the variable is referenced twice, even in the same statement, then you are prompted twice.
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
yanoolthecool
11 months agomrcsp
1 year, 3 months agoOraclestd24
1 year, 1 month agolucemqy
1 year, 5 months agoWingL
1 year, 10 months ago