Oracle
1Z0-061 · Question #28
View the Exhibit and examine the structure of the products table. Evaluate the following query: What would be the outcome of executing the above SQL statement?
The correct answer is C. It shows the names of products whose list price is the second highest in the table. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the products table. Evaluate the following query:
What would be the outcome of executing the above SQL statement?
Exhibits
Options
- AIt produces an error.
- BIt shows the names of all products in the table.
- CIt shows the names of products whose list price is the second highest in the table.
- DIt shows the names of all products whose list price is less than the maximum list price.
How the community answered
(37 responses)- A16% (6)
- B8% (3)
- C73% (27)
- D3% (1)
Community Discussion
No community discussion yet for this question.

