Skip to content
Early access — you're among the first to try PYQLabs. Share feedback
Concept drill

Outer Join

GATE CSE & IT · SQL · 2018-2018

2
PYQs
100%
keyed
0
elite explanations
1
years appeared

Study anchor

Korth — Database System Concepts

Relational model, SQL, normalization, transactions

Practice action

Start latest PYQ

PYQs in this concept

All concepts →
2018 PYQ

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 =...

easyanswer key
2018 PYQ

Consider the relations $$r(A, B)$$ and $$s(B, C),$$ where $$s.B$$ is a primary key and $$r.B$$ is a foreign key referencing $$s.B.$$ Consider the query $$Q:$$ $$\,\,\,\,\,\,\,\,\,$...

mediumanswer keybasic explanation