The PRODUCTS table has these columns:
PRODUCT_ID NUMBER(4)
PRODUCT_NAME VARCHAR2(45)
PRICE NUMBER(8,2)
Evaluate this SQL statement:
SELECT *
FROM PRODUCTS
ORDER BY price, product_name;
What is true about the SQL statement?
A.
The results are not sorted.
B.
The results are sorted numerically.
C.
The results are sorted alphabetically.
D.
The results are sorted numerically and then alphabetically.
Explanation:
the result is sort by price which is numeric and follow by product_name which is alphabetically.Incorrect answer:
Athe results are sorted
Bthe results are sorted with alphabetically as well
Cthe results are sorted with numerically as well