Examine the following query: SQL> SELECT prod_id, amount_sold FROM sales - ORDER BY amount_sold - FETCH FIRST 5 PERCENT ROWS ONLY; What is the output of this query? 

Answer options:

A. It displays 5 percent of the products with the highest amount sold.
B. It displays the first 5 percent of the rows from the SALES table.
C. It displays 5 percent of the products with the lowest amount sold.
D. It results in an error because the ORDER BY clause should be the last clause.

C

References: https://oracle-base.com/articles/12c/row-limiting-clause-for-top-n-queries-12cr1