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

Directions (Q96–100): Consider the relations X(S, Si, C) and Y(S, P, D):

X
SSiC
J1M
B2N
R3H
T4G
Y
SPD
JS1CA
BP1AB
RD1DC
AH1MD

The result of the operation X ⟖X.S = Y.S Y (right outer join) will be:

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

Show answer & explanation

Correct answer: B.

S  Si    C     P   D
J  1     M     S1  CA
B  2     N     P1  AB
R  3     H     D1  DC
A  NULL  NULL  H1  MD

Explanation

A right outer join keeps every Y tuple: J, B, R match, and A (only in Y) appears with NULL for Si and C.

More Database Management Systems questions