Concept drill
nested-query
GATE CSE & IT · SQL · 2007-2014
3
PYQs
100%
keyed
0
elite explanations
3
years appeared
Study anchor
Korth — Database System Concepts
Relational model, SQL, normalization, transactions
Practice action
Start latest PYQPYQs in this concept
All concepts →2014 PYQ
SQL allows duplicate tuples in relations, and correspondingly defines the multiplicity of tuples in the result of joins. Which one of the following queries always gives the same an...
mediumanswer key
2010 PYQ
A relational schema for a train reservation database is given below: Passenger ( pid, pname, age) Reservation (pid, cass, tid) Table: Passenger pid pname age 0 'Sachin' 65 1 'Rahul...
mediumanswer key
2007 PYQ
Consider the table employee(empId, name, department, salary) and the two queries Q 1 , Q 2 below. Assuming that department 5 has more than one employee, and we want to find the emp...
mediumanswer key