Big Halloween Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

  1. Home
  2. Discussions
  3. Oracle
  4. Oracle Database 19c
  5. 1z0-082 Discussions
  6. 1z0-082 Exam Topic 1 Question 5 Discussion

Oracle Database Administration I 1z0-082 Question # 5 Topic 1 Discussion

 Oracle Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Oracle Database Administration I 1z0-082 Question # 5 Topic 1 Discussion

1z0-082 Exam Topic 1 Question 5 Discussion:
Question #: 5
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, &&col2FROM &tableWHERE &&condition = &&cond;

B.

SELECT &col1, &col2FROM &&tableWHERE &condition;

C.

SELECT &col1, &col2FROM “&table”WHERE &condition;

D.

SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;

E.

SELECT &&col1, &&col2FROM &tableWHERE &&condition;

Get Premium 1z0-082 Questions
Actual exam question for Oracle 1z0-082 exam by Onyx7092 at Aug 2, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next