Oracle Exam 1Z0-082 Topic 6 Question 3 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 3
Topic #: 6

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?

ASELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;

BSELECT &col1, &col2FROM &&tableWHERE &condition;

CSELECT &col1, &col2FROM ''&table''WHERE &condition;

DSELECT '&&col1', '&&col2'FROM &tableWHERE '&&condition' = '&cond';

ESELECT &&col1, &&col2FROM &tableWHERE &&condition;

Show Suggested Answer

Suggested Answer: B

by Jaclyn at May 06, 2022, 05:00 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!