1)INNER JOIN 2)LEFT OUTERJOIN 4)RIGHT OUTER JOIN 5)FULL OUTER JOIN WITH A)Returns records that have matching values in both tables B)Returns the matched records
Answer options
A
from the
B
right table, and all records from the left table C)Returns the matched records from the left
C
table, and
D
all records from the right table D)Returns all records when there is a match in either left or
E
right
F
table
G
a>1-d,2-c,3-b,4-a
H
b>1-d,2-b,3-c,4-1
I
c>1-d,2-b,3-a,4-c
J
d>1-a,2-b,3-c,4-d
Correct answer: d>1-a,2-b,3-c,4-d
Explanation
Standard SQL JOIN mappings: 1-INNER JOIN=A (matching values in both), 2-LEFT OUTER=B (all left, matched right), 3-RIGHT OUTER=C (all right, matched left), 4-FULL OUTER=D (all when match in either). Option 9 'd>1-a,2-b,3-c,4-d' represents this correct mapping.