ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam
Go to Exam

Exam 1z0-082 topic 1 question 13 discussion

Actual exam question from Oracle's 1z0-082
Question #: 13
Topic #: 1
[All 1z0-082 Questions]

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 Hide Answer
Suggested Answer: B 🗳️
by avanand at Aug. 22, 2020, 6:49 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
avanand
Highly Voted 3 years, 4 months ago
B is correct
upvoted 8 times
...
nautil2
Most Recent 4 months ago
Selected Answer: B
B – TRUE; value of variables prefixed with && is stored and not requested repeatedly
upvoted 1 times
...
zouve
5 months, 1 week 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, 6 months ago
Selected Answer: B
B is correct
upvoted 1 times
...
Datajimm
1 year, 10 months ago
Selected Answer: B
single & prompts for input for every run double && prompts for input only on the first run
upvoted 1 times
...
ryuah
2 years ago
B is correct
upvoted 1 times
...
baeji
3 years ago
B is correct
upvoted 2 times
...
adoptc94
3 years, 4 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
...
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.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago