nerdexam
Broadcom-VMware

5V0-91.20 · Question #32

An administrator runs multiple queries on tables and combines the results after the fact to correlate data. The administrator needs to combine rows from multiple tables based on data from a related…

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

Question

An administrator runs multiple queries on tables and combines the results after the fact to correlate data. The administrator needs to combine rows from multiple tables based on data from a related column in each table. Which SQL statement should be used to achieve this goal?

Options

  • AJOIN
  • BWHERE
  • CAS
  • DCOMBINE

How the community answered

(39 responses)
  • A
    72% (28)
  • B
    8% (3)
  • C
    3% (1)
  • D
    18% (7)

Community Discussion

No community discussion yet for this question.

Full 5V0-91.20 Practice