ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam
Go to Exam

Exam 98-364 topic 1 question 140 discussion

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

This question requires that you evaluate the underlined text to determine if it is correct.
The UNION keyword combines the results of two queries and returns only rows that appear in both result sets.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

  • A. No change is needed
  • B. INTERSECT
  • C. ALL
  • D. JOIN
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
UNION combines the results from both queries.
INTERSECT returns rows that are common to both queries
Exam B
by CatDragon at Oct. 31, 2019, 7:35 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Pryns
Highly Voted 5 years, 7 months ago
The underlined word is UNION. Usually the uppercase word is the underlined word.
upvoted 5 times
...
NinjaTurtle
Highly Voted 5 years, 3 months ago
The answer to this question is B/INTERSECT. SQLServer Tutorial.net
upvoted 5 times
...
dzoni68
Most Recent 3 years ago
The correct answer is INTERSECT. Option B.
upvoted 1 times
...
Garyours
4 years, 8 months ago
B is correct.
upvoted 1 times
...
CatDragon
5 years, 7 months ago
Again, no underlined text
upvoted 1 times
...
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