GATE Computer Science (CS) 2018 Shift 1 Solved Paper
© examsiri.com
Question : 23 of 65
Marks:
+1,
-0
Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock (isbn, copies)
Query 1: { SELECT B.isbn, S.copies }
FROM Book B INNER JOIN
Stock S
ON B.isbn S.isbn;
Query 2: SELECT B.isbn, S.copies
FROM Book B LEFT OUTER
JOIN Stock S
ON B.isbn S.isbn:
Query 3: SELECT B.isbn, S.copies
FROM Book B RIGHT JOIN
Stock s
ON B.isbn = S.isbn;
Query 4: SELECT B.isbn, S.copies
FROM Book B FULL OUTER
JOIN Stock S
ON B.isbn S.isbn;
Which one of the queries above is certain to have an output that is superset of the outputs of the other three queries?
Query 1: { SELECT B.isbn, S.copies }
FROM Book B INNER JOIN
Stock S
ON B.isbn S.isbn;
Query 2: SELECT B.isbn, S.copies
FROM Book B LEFT OUTER
JOIN Stock S
ON B.isbn S.isbn:
Query 3: SELECT B.isbn, S.copies
FROM Book B RIGHT JOIN
Stock s
ON B.isbn = S.isbn;
Query 4: SELECT B.isbn, S.copies
FROM Book B FULL OUTER
JOIN Stock S
ON B.isbn S.isbn;
Which one of the queries above is certain to have an output that is superset of the outputs of the other three queries?
Go to Question: