nerdexam
Zend

ZF-100-500 · Question #39

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

The correct answer is B. 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

  • ASelf join
  • BOuter join
  • CEquijoin
  • DNon-equijoin

How the community answered

(34 responses)
  • A
    15% (5)
  • B
    74% (25)
  • C
    9% (3)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full ZF-100-500 Practice