nerdexam
Microsoft

98-364 · Question #208

You need to combine the results of two queries into a single result that contains all of the rows from both queries. Which Structured Query Language (SQL) statement should you use?

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

Question

You need to combine the results of two queries into a single result that contains all of the rows from both queries. Which Structured Query Language (SQL) statement should you use?

Options

  • ATRUNCATE
  • BJOIN
  • CEXCEPT
  • DUNION

How the community answered

(47 responses)
  • A
    9% (4)
  • B
    15% (7)
  • C
    2% (1)
  • D
    74% (35)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice