Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

© examsnet.com

Question : 30 of 50

Marks: +1, -0

You must write a query that prompts users for column names and conditions every time it is executed.

The user must be prompted only once for the table name.

Which statement achieves those objectives?

SELECT &col1, '&col2' FROM &table WHERE &&condition = '&cond';
SELECT &col1, &col2 FROM "&table" WHERE &condition = &cond;
SELECT &col1, &col2 FROM &&table WHERE &condition = &cond;
SELECT &col1, &col2 FROM &&table WHERE &condition = &&cond

Go to Question:

Advertisements