Computer Science · Database Management Systems
Given Relation R(AI, AII, AIII) containing tuples (1, 2, 3), (4, 5, 6), (7, 8, 9) and Relation S(AIV, AV) containing tuples (3, 1), (6, 2). The θ-join of relations R and S given by R  join;AII < AIV S produces which result?
- 1Tuples: (7, 8, 9, 6, 2) and (7, 8, 9, 3, 1)
- 2No tuples get selected
- 3Tuples: (1, 2, 3, 3, 1) and (1, 2, 3, 6, 2)
- 4Tuples: (1, 2, 3, 3, 1), (1, 2, 3, 6, 2), and (4, 5, 6, 6, 2)✓
Correct answer
Tuples: (1, 2, 3, 3, 1), (1, 2, 3, 6, 2), and (4, 5, 6, 6, 2)
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on Database Management Systems?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Database Management Systems