PrepAway - Latest Free Exam Questions & Answers

Which of the following SQL statements would return all complete tuples for order dates in 2002, arranged by am

Consider the Orders relation shown in the exhibit.

Which of the following SQL statements would return all complete tuples for order dates in 2002, arranged by amount from lowest to highest?

PrepAway - Latest Free Exam Questions & Answers

A.
SELECT *
FROM Orders
WHERE Order_Date LIKE _02
ORDER BY Amount;

B.
SELECT (Order_Date, Amount)
FROM Orders
WHERE Order_Date LIKE %02
ORDER BY Amount;

C.
SELECT *
FROM Orders
WHERE Order_Date LIKE _02
ORDER BY Order_No;

D.
SELECT *
FROM Orders
WHERE Order_Date LIKE %02
ORDER BY Amount;


Leave a Reply