Live Quiz Arena
🎁 1 Free Round Daily
⚡ Enter ArenaQuestion
← Logic & PuzzlesWhat happens to a database query result when the set theory principle of 'union' combines two tables with completely disjoint sets of primary keys?
A)A smaller set is produced
B)Only common entries are included
C)A larger, combined set results✓
D)An empty set will always result
💡 Explanation
A 'union' operation, by set theory definition, creates a new set containing all distinct elements from both original sets; because the primary keys are disjoint, no overlap exists, therefore the resulting set contains all elements from both, forming a larger set, rather than filtering or reducing the set.
🏆 Up to £1,000 monthly prize pool
Ready for the live challenge? Join the next global round now.
*Terms apply. Skill-based competition.
Related Questions
Browse Logic & Puzzles →- An engineer designs a braking system under the assumption that a car can simultaneously be both stopped and moving at a non-zero velocity. Which consequence follows?
- A cleaning robot navigates a warehouse, using a potential function to minimize travel. If the robot gets stuck in a local minimum, which behavior is most likely?
- If a database query returns all customer records where the 'city' field is either 'New York' OR 'Los Angeles', which set theory operation models this?
- A mechanical linkage transforms rotational motion to linear. If the linkage exhibits spatial reflection symmetry across its central axis, which consequence follows?
- What happens to the computational cost for an attacker when a cryptographic hash function loses its second preimage resistance?
- If you distribute 7 identical apples among 3 distinct children, which counting method accounts for overcounting when using stars and bars?
