NEW
New Website Launch
Experience the best way to solve previous year questions with mock tests (very detailed analysis), bookmark your favourite questions, practice etc...
VISIT NOW

GATE CSE

Structured Query Language

Database Management System

Previous Years Questions

Marks 1

More
Consider the relational database with the following four schemas and their respective instances. Student( $$\underline {...
GATE CSE 2022
Consider a relational database containing the following schemas. The primary key of each table is indicated by underlyi...
GATE CSE 2020
Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock (isbn, copies)Query 1: SELECT B.isb...
GATE CSE 2018
Consider the following relation $$\,\,\,\,\,\,\,\,$$ Cinema(theater, address, capacity) Which of the following options w...
GATE CSE 2015 Set 3
SELECT operation in SQL is equivalent to
GATE CSE 2015 Set 1
Given the following statements: S1: A foreign key declaration can always be replaced by an equivalent check assertion in...
GATE CSE 2014 Set 1
Which of the following statements are TRUE about an SQL query? P: An SQL query can contain a HAVING clause even if it do...
GATE CSE 2012
A relational schema for a train reservation database is given below: Passenger ( pid, pname, age) Reservation (pid, cas...
GATE CSE 2010
Consider the following relation schema pertaining to a students database: Students (rollno, name, address) Enroll(rollno...
GATE CSE 2004

Marks 2

More
A relational database contains two tables Student and Performance as shown below: The primary key of the Student table ...
GATE CSE 2019
Consider the following database table named $$water$$_$$schemes :$$ .tg {border-collapse:collapse;border-spacing:0;bor...
GATE CSE 2016 Set 2
Consider the following relation: Student .tg {border-collapse:collapse;border-spacing:0;} .tg td{font-family:Arial, s...
GATE CSE 2015 Set 1
SQL allows duplicate tuples in relations, and correspondingly defines the multiplicity of tuples in the result of joins....
GATE CSE 2014 Set 2
Given the following schema: employees(emp-id, first-name, last-name, hire-date, dept-id, salary) departments(dept-id, d...
GATE CSE 2014 Set 1
Consider the following relational schema: employee (empId, empName, empDept ) customer (custId, custName, salesRepId, ra...
GATE CSE 2014 Set 3
Consider the following relational schema. Students(rollno: integer, sname: string) Courses(courseno: integer, cname: str...
GATE CSE 2013
Consider a database table T containing two columns X and Y each of type integer. After the creation of the table, one re...
GATE CSE 2011
Database table by name Loan_Records is given below. .tg {border-collapse:collapse;border-spacing:0;} .tg td{font-famil...
GATE CSE 2011
Consider the following relational schema: Suppliers(sid : integer, sname : string, city : string, street : string) Parts...
GATE CSE 2009
Consider the following relational schema: Suppliers(sid : integer, sname : string, city : string, street : string) Parts...
GATE CSE 2009
Consider The Following Relational Scheme Student (school-id, sch-roll-no, sname, saddress) School (school-id, sch-name, ...
GATE CSE 2008
Consider The Following Relational Scheme Student (school-id, sch-roll-no, sname, saddress) School (school-id, sch-name, ...
GATE CSE 2008
Consider the table employee(empId, name, department, salary) and the two queries Q1, Q2 below. Assuming that department ...
GATE CSE 2007
Consider a database with three relation instances shown below. The primary keys for the Drivers and Cars relation are Di...
GATE CSE 2006
Consider a database with three relation instances shown below. The primary keys for the Drivers and Cars relation are Di...
GATE CSE 2006
Consider the relation "enrolled (student, course)" in which (student, course) is the primary key, and the relation "paid...
GATE CSE 2006
Consider the relation account (customer, balance) where customer is a primary key and there are no null values. We would...
GATE CSE 2006
In an inventory management system implemented at a trading corporation, there are several tables designed to hold all th...
GATE CSE 2005
The relation book (title, price) contains the titles and prices of different books. Assuming that no two books have the ...
GATE CSE 2005
A company maintains records of sales made by its salespersons and pays them commission based on each individual’s total ...
GATE CSE 2005
Consider two tables in a relational database with columns and rows as follows:  Table: Student .tg {border-collap...
GATE CSE 2004
A relational database contains two table student and department in which student table has columns roll_no, name and dep...
GATE CSE 2004
The employee information in a company is stored in the relation Employee (name, sex, salary, deptName) Consider the foll...
GATE CSE 2004
Consider the set of relations shown below and the SQL query that follows. Students: (Roll_number, Name, Date_of_birth) C...
GATE CSE 2003
In SQL, relations can contain null values, and comparisons with null values are treated as unknown. Suppose all comparis...
GATE CSE 2000
Given relations r( w, x ) and s( y, z ), the result of select distinct w,x from r, s; is guaranteed to be same as r, pr...
GATE CSE 2000
Consider the set of relations EMP (Employee-no, Dept-no, Employee-name, Salary) DEPT (Dept-no, Dept-name, Location) Writ...
GATE CSE 1999
Which of the following is/are correct?
GATE CSE 1999
Suppose we have a database consisting of the following three relations. FREQUENTS (student, parlor) giving the parlors e...
GATE CSE 1998

Joint Entrance Examination

JEE Main JEE Advanced WB JEE

Graduate Aptitude Test in Engineering

GATE CSE GATE ECE GATE EE GATE ME GATE CE GATE PI GATE IN

Medical

NEET

CBSE

Class 12