Exam 1z0-082 topic 1 question 13 discussion

Actual exam question from Oracle's 1z0-082

Question #: 13
Topic #: 1

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?

A. SELECT &&col1, &&col2 FROM &table WHERE &&condition = &&cond;
B. SELECT &col1, &col2 FROM &&table WHERE &condition;
C. SELECT &col1, &col2 FROM ג€&tableג€ WHERE &condition;
D. SELECT '&&col1', '&&col2' FROM &table WHERE '&&condition' = '&cond';
E. SELECT &&col1, &&col2 FROM &table WHERE &&condition;

Show Suggested Answer

Suggested Answer: B 🗳️

by avanand at Aug. 22, 2020, 6:49 p.m.

Comments

Submit Cancel

avanand

Highly Voted 3 years, 10 months ago

B is correct

upvoted 8 times

...

nautil2

Most Recent 9 months, 2 weeks ago

Selected Answer: B

B – TRUE; value of variables prefixed with && is stored and not requested repeatedly

upvoted 1 times

...

zouve

10 months, 2 weeks ago

Selected Answer: B

the correct queries are : A. SELECT &&col1, &&col2 FROM &table WHERE &&condition = &&cond; B. SELECT &col1, &col2 FROM &&table WHERE &condition; C. SELECT &col1, &col2 FROM "&&table" WHERE &condition; D. SELECT '&&col1', '&&col2' FROM &table WHERE '&&condition' = '&cond'; E. SELECT &&col1, &&col2 FROM &table WHERE &&condition; these are copy-paste from 1Z0-071

upvoted 1 times

...

LeandroHPN

1 year, 11 months ago

Selected Answer: B

B is correct

upvoted 1 times

...

Datajimm

2 years, 3 months ago

Selected Answer: B

single & prompts for input for every run double && prompts for input only on the first run

upvoted 2 times

...

ryuah

2 years, 5 months ago

B is correct

upvoted 1 times

...

baeji

3 years, 6 months ago

B is correct

upvoted 2 times

...

adoptc94

3 years, 10 months ago

Correct answer: B Tested in SQL-Developer, col1, col2 and condition will be prompted everytime, while table will only be prompted the first time you execute this statement

upvoted 4 times

...