nerdexam
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

1Z0-061 question #28 exhibit 1
1Z0-061 question #28 exhibit 2

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)
  • A
    16% (6)
  • B
    8% (3)
  • C
    73% (27)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice