nerdexam
CIW

1D0-541 · Question #36

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?

The correct answer is D. SELECT *. See the full explanation below for the reasoning.

Question

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?

Exhibit

1D0-541 question #36 exhibit

Options

  • ASELECT *
  • BSELECT (Order_Date, Amount)
  • CSELECT *
  • DSELECT *

How the community answered

(58 responses)
  • A
    14% (8)
  • B
    3% (2)
  • C
    7% (4)
  • D
    76% (44)

Community Discussion

No community discussion yet for this question.

Full 1D0-541 Practice