An operator returning tuples belonging to both relations is:
AIntersection
BInterpolation
CInterception
DInterruption
Answer & Solution
Correct answer: A. Intersection
1. Union keeps rows in either relation.
2. This one keeps only rows in both.
3. That operator is Intersection.
_Source: OpenStax Introduction to Computer Science, Chapter 8, Data Management._
Keep practising Relational Databases
Browse all Relational Databases questions for Computer Science — Tanzania, or explore more Computer Science topics.