Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Microsoft Discussions

Exam 98-364 topic 1 question 103 discussion

Actual exam question from Microsoft's 98-364
Question #: 103
Topic #: 1
[All 98-364 Questions]

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?

  • A. INTERSECT
  • B. UNION
  • C. JOIN
  • D. TRUNCATE
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Difdoor at June 26, 2019, 7:03 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Difdoor
Highly Voted 4 years, 10 months ago
The answer should be C. A "UNION" does not require the tables have any relationship, only that the queries have output columns with the same datatype
upvoted 20 times
...
Pryns
Highly Voted 4 years, 5 months ago
UNION returns all the rows from both table. JOIN returns row that is exactly in both tables. The answer for thid question is JOIN.
upvoted 8 times
...
dim37
Most Recent 8 months ago
Selected Answer: C
join join join
upvoted 1 times
...
OgYrKo
1 year, 10 months ago
Selected Answer: C
Answer is C
upvoted 2 times
...
dzoni68
1 year, 11 months ago
The answer is JOIN. (C) A JOIN clause is used to combine rows from two or more tables, based on a related column between them.
upvoted 1 times
...
Cheerss
2 years, 1 month ago
The Answer is JOIN please. Keyword: Relationship between the tables to be combined is based on a COLUMN that exists in both tables.
upvoted 1 times
...
robertscobar
2 years, 6 months ago
Join is correct
upvoted 2 times
...
Morgane
2 years, 6 months ago
C. JOIN would be the answer (though I understand INTERSECT might give similar results), because you retrieve the data from two tables on a common column (a JOIN). UNION would be more to combine results/queries.
upvoted 1 times
...
xGSTx
3 years, 2 months ago
it can be JOIN or INTERSECT
upvoted 2 times
...
Andy7622
3 years, 5 months ago
JOIN is to connect tables on the base of the common column
upvoted 3 times
...
CertMeUp
3 years, 7 months ago
Correct answer is C.
upvoted 2 times
...
Tiks
3 years, 10 months ago
C is the correct one
upvoted 2 times
...
Ikhlaq
4 years, 5 months ago
C is the correct answer. JOIN
upvoted 6 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel