PrepAway - Latest Free Exam Questions & Answers

Which of the following queries will yield the desired results?

Given the following two tables:
TAB1
C1 C2
__ __
A 11
B 12
C 13
TAB2
CX CY
__ __
A 21
C 22
D 23
The following results are desired:
C1 C2 CX CY
__ __ __ __

A 11 A 21
C 13 C 22
— — D 23
Which of the following queries will yield the desired results?

PrepAway - Latest Free Exam Questions & Answers

A.
SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx

B.
SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx

C.
SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx

D.
SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx

One Comment on “Which of the following queries will yield the desired results?


Leave a Reply