nerdexam
Oracle

1Z0-071 · Question #49

Examine the following query: What is the output of this query?

The correct answer is C. It displays 5 percent of the products with the lowest amount sold. See the full explanation below for the reasoning.

Question

Examine the following query:

What is the output of this query?

Options

  • AIt displays 5 percent of the products with the highest amount sold.
  • BIt displays the first 5 percent of the rows from the SALES table.
  • CIt displays 5 percent of the products with the lowest amount sold.
  • DIt results in an error because the ORDER BY clause should be the last clause.

How the community answered

(23 responses)
  • A
    4% (1)
  • C
    83% (19)
  • D
    13% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice