Test Index

GATE Computer Science (CS) 2018 Shift 1 Solved Paper

© examsnet.com

Question : 23

Total: 65

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
Query 2
Query 3
Query 4

Go to Question:

Prev Question

Next Question