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

Exam C2090-616 All Questions

View all questions & answers for the C2090-616 exam
Go to Exam

Exam C2090-616 topic 1 question 40 discussion

Actual exam question from IBM's C2090-616
Question #: 40
Topic #: 1
[All C2090-616 Questions]

Which of the following set operators can be used to find all rows that are common in 2 queries?

  • A. UNION
  • B. UNION ALL
  • C. EXCEPT ALL
  • D. INTERSECT ALL
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by db2tester at Oct. 9, 2019, 12:30 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
pieknyjoe
4 years, 5 months ago
C is INCORRECT! "INTERSECT ALL" >>??
upvoted 2 times
...
dbadmin
4 years, 10 months ago
The correct answer is A - UNION. union all and intersect all will display the duplicates. Question is to find all rows that are in common ( Means distinct).
upvoted 2 times
zarko
4 years, 1 month ago
common means found both in a and in b. that is intersect.
upvoted 1 times
...
...
db2tester
5 years, 1 month ago
The correct answer is C- Intersect. INTERSECT is used to match result sets between two tables. If the data is the same in both results sets, it passes through. When INTERSECT ALL is specified, the result consists of all rows that are in both results sets. If INTERSECT is specified without the ALL option, the duplicates will be removed from the results. Reference : https://www.datavail.com/blog/using-intersect-and-except-in-db2/
upvoted 2 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