Multiple Choice
The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is .
A) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT SEQUENCE BY P_PRICE;
B) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT LIST BY P_PRICE;
C) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;
D) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ASCENDING BY P_PRICE;
Correct Answer:

Verified
Correct Answer:
Verified
Q14: A(n) _ is an alternate name given
Q15: Which of the following queries is used
Q24: A common practice is to create a(n)
Q26: The _ command, coupled with appropriate search
Q31: Only numeric data types can be added
Q41: The COMMIT command does not permanently save
Q51: Which of the following queries will output
Q66: The conditional LIKE must be used in
Q100: According to the rules of precedence, which
Q104: The command is used with the ALTER