nerdexam
CIW

1D0-441 · Question #47

Consider the Recreation Relation shown in the exhibit. You need to apply a SQL statement to the Recreation Relation that will return the following data: Bowling Racquetball Handball Fencing Which…

The correct answer is B. SELECT DISTINCT Activity FROM Recreation. See the full explanation below for the reasoning.

Question

Consider the Recreation Relation shown in the exhibit. You need to apply a SQL statement to the Recreation Relation that will return the following data: Bowling Racquetball Handball Fencing Which SQL statement applied to the Recreation Relation will return this data?

Exhibit

1D0-441 question #47 exhibit

Options

  • ASELECT Activity FROM Recreation;
  • BSELECT DISTINCT Activity FROM Recreation;
  • CSELECT Activity FROM Recreation
  • DSELECT Activity FROM Recreation

How the community answered

(45 responses)
  • A
    16% (7)
  • B
    71% (32)
  • C
    9% (4)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 1D0-441 Practice