What is true about the SQL statement?

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?

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:
A:
the results are sorted
B:
the results are sorted with alphabetically as well
C:
the results are sorted with numerically as well
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 2-2



Leave a Reply 1

Your email address will not be published. Required fields are marked *