nerdexam
Zend

200-530 · Question #490

Which of the following joins retrieves all rows from one table and only the matching rows from the joined table?

The correct answer is D. Outer join. See the full explanation below for the reasoning.

Question

Which of the following joins retrieves all rows from one table and only the matching rows from the joined table?

Options

  • ANon-equijoin
  • BEquijoin
  • CSelf join
  • DOuter join

How the community answered

(23 responses)
  • A
    9% (2)
  • B
    4% (1)
  • C
    4% (1)
  • D
    83% (19)

Community Discussion

No community discussion yet for this question.

Full 200-530 Practice