All mock tests are FREE till 31 December — register to save your progress
Unit 4 · Database Management Systems Paper 2 CS · December 2022 Shift 2

Identify the correct operation that produces the given output from the two relations R1 and R2.

R1

NameClass
a19
b15
c16
d111

R2

NameClass
b15
f18

Output

NameClass
b15

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: A. R1 ∩ R2

Explanation

The only common tuple is (b1, 5), which is R1 ∩ R2. (R1 − (R1 − R2) is an equivalent way to write the intersection.)

More Database Management Systems questions