PrepSnap logoPrepSnap
Pass

Question

1.
2.
3.
4.
Answer (Detailed Solution Below)

Option 1 : 4 / 4

Advertisement

Detailed Solution

सही उत्तर 4 / 4 है।

Key Points
Helpful?
PrepSnapprepsnap.in • Part -A

Question:

Table A has join-key values {1, 2, 3} and table B has join-key values {3, 4, 5}, with no duplicates. How many more rows does SELECT * FROM A FULL OUTER JOIN B ON A.k = B.k; return than the INNER JOIN of the same tables? / तालिका A में जॉइन-कुंजी मान {1, 2, 3} हैं और तालिका B में {3, 4, 5} हैं, बिना दोहराव के। SELECT * FROM A FULL OUTER JOIN B ON A.k = B.k; समान तालिकाओं के INNER JOIN से कितनी अधिक पंक्तियां लौटाएगा?

1.
4 / 4
2.
5 / 5
3.
2 / 2
4.
3 / 3

Correct Answer: 4 / 4

The INNER JOIN returns only the common key {3} — 1 row. The FULL OUTER JOIN returns all distinct keys {1, 2, 3, 4, 5} — 5 rows. Difference = 5 − 1 = 4. / INNER JOIN केवल उभयनिष्ठ कुंजी {3} लौटाता है — 1 पंक्ति। FULL OUTER JOIN सभी भिन्न कुंजियां {1, 2, 3, 4, 5} लौटाता है — 5 पंक्तियां। अंतर = 5 − 1 = 4।

Downloaded from PrepSnap (prepsnap.in)