nerdexam
Microsoft

98-364 · Question #227

You need to retrieve data from two related database tables based on a column that exists in both tables. Which command should you use in a query?

The correct answer is C. JOIN. See the full explanation below for the reasoning.

Question

You need to retrieve data from two related database tables based on a column that exists in both tables. Which command should you use in a query?

Options

  • AINTERSECT
  • BUNION
  • CJOIN
  • DTRUNCATE

How the community answered

(15 responses)
  • A
    7% (1)
  • B
    7% (1)
  • C
    87% (13)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice