Oracle
1Z0-071 · Question #153
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?
The correct answer is C. SELECT &col1, &col2. See the full explanation below for the reasoning.
Question
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?
Options
- ASELECT &col1, '&col2'
- BSELECT &col1, &col2
- CSELECT &col1, &col2
- DSELECT &col1, &col2
How the community answered
(31 responses)- A3% (1)
- B10% (3)
- C84% (26)
- D3% (1)
Community Discussion
No community discussion yet for this question.