Structured Query Language · Database Management System · GATE CSE
Start PracticeMarks 1
GATE CSE 2020
Consider a relational database containing the following schemas.
The primary key of each table is indicated by underlying the constituent fields.
SEL...
GATE CSE 2018
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...
GATE CSE 2015 Set 1
SELECT operation in SQL is equivalent to
GATE CSE 2015 Set 3
Consider the following relation
$$\,\,\,\,\,\,\,\,$$ Cinema(theater, address, capacity)
Which of the following options will be needed at the end of th...
GATE CSE 2014 Set 1
Given the following statements:
S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL.
S2: Given the table R(a,...
GATE CSE 2012
Which of the following statements are TRUE about an SQL query?
P: An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause
...
GATE CSE 2010
A relational schema for a train reservation database is given below:
Passenger ( pid, pname, age)
Reservation (pid, cass, tid)
Table: Passenger
.tg...
GATE CSE 2004
Consider the following relation schema pertaining to a students database:
Students (rollno, name, address)
Enroll(rollno,courseno, coursename)
Where t...
Marks 2
GATE CSE 2023
Consider the following table named Student in a relational database. The primary key of this table is rollNum.
Student
.tg {border-collapse:collapse...
GATE CSE 2022
Consider the relational database with the following four schemas and their respective instances.
Student( $$\underline {sNo} $$ , sName, dNo) Dept( $$...
GATE CSE 2021 Set 2
The relation scheme given below is used to store information about the employees of a company, where empId is the key and deptId indicates the departm...
GATE CSE 2019
A relational database contains two tables Student and Performance as shown below :
The primary key of the Student table is Roll_no. For the Performan...
GATE CSE 2016 Set 2
Consider the following database table named $$water$$_$$schemes :$$
.tg {border-collapse:collapse;border-spacing:0;border-width:1px;border-style:sol...
GATE CSE 2015 Set 1
Consider the following relation:
Student
.tg {border-collapse:collapse;border-spacing:0;}
.tg td{font-family:Arial, sans-serif;font-size:14px;paddi...
GATE CSE 2014 Set 3
Consider the following relational schema:
employee (empId, empName, empDept ) customer (custId, custName, salesRepId, rating)
SalesRepId is a foreign...
GATE CSE 2014 Set 2
SQL allows duplicate tuples in relations, and correspondingly defines the multiplicity of tuples in the result of joins. Which one of the following qu...
GATE CSE 2014 Set 1
Given the following schema:
employees(emp-id, first-name, last-name, hire-date, dept-id, salary)
departments(dept-id, dept-name, manager-id, location...
GATE CSE 2013
Consider the following relational schema.
Students(rollno: integer, sname: string) Courses(courseno: integer, cname: string) Registration(rollno: inte...
GATE CSE 2011
Database table by name Loan_Records is given below.
.tg {border-collapse:collapse;border-spacing:0;}
.tg td{font-family:Arial, sans-serif;font-size:...
GATE CSE 2011
Consider a database table T containing two columns X and Y each of type integer. After the creation of the table, one record (X = 1, Y = 1) is inserte...
GATE CSE 2009
Consider the following relational schema:
Suppliers(sid : integer, sname : string, city : string, street : string)
Parts(pid : integer, pname : string...
GATE CSE 2009
Consider the following relational schema:
Suppliers(sid : integer, sname : string, city : string, street : string)
Parts(pid : integer, pname : string...
GATE CSE 2008
Consider The Following Relational Scheme
Student (school-id, sch-roll-no, sname, saddress)
School (school-id, sch-name, sch-address, sch-phone)
Enrolm...
GATE CSE 2008
Consider The Following Relational Scheme
Student (school-id, sch-roll-no, sname, saddress)
School (school-id, sch-name, sch-address, sch-phone)
Enrolm...
GATE CSE 2007
Consider the table employee(empId, name, department, salary) and the two queries Q1, Q2 below. Assuming that department 5 has more than one employee, ...
GATE CSE 2006
Consider the relation account (customer, balance) where customer is a primary key and there are no null values. We would like to rank customers accord...
GATE CSE 2006
Consider the relation "enrolled (student, course)" in which (student, course) is the primary key, and the relation "paid (student, amount)" where stud...
GATE CSE 2006
Consider a database with three relation instances shown below. The primary keys for the Drivers and Cars relation are Did and cid respectively and the...
GATE CSE 2006
Consider a database with three relation instances shown below. The primary keys for the Drivers and Cars relation are Did and cid respectively and the...
GATE CSE 2005
The relation book (title, price) contains the titles and prices of different books. Assuming that no two books have the same price, what does the foll...
GATE CSE 2005
A company maintains records of sales made by its salespersons and pays them commission based on each individual’s total sales made in a year. This dat...
GATE CSE 2005
In an inventory management system implemented at a trading corporation, there are several tables designed to hold all the information. Amongst these, ...
GATE CSE 2004
Consider two tables in a relational database with columns and rows as follows:
Table: Student
.tg {border-collapse:collapse;border-spacing:0;}...
GATE CSE 2004
A relational database contains two table student and department in which student table has columns roll_no, name and dept_id and department table has ...
GATE CSE 2004
The employee information in a company is stored in the relation
Employee (name, sex, salary, deptName)
Consider the following SQL query
Select deptN...
GATE CSE 2003
Consider the set of relations shown below and the SQL query that follows.
Students: (Roll_number, Name, Date_of_birth)
Courses: (Course number, Course...
GATE CSE 2000
In SQL, relations can contain null values, and comparisons with null values are treated as unknown. Suppose all comparisons with a null value are trea...
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, provided...
GATE CSE 1999
Which of the following is/are correct?
GATE CSE 1999
Consider the set of relations
EMP (Employee-no, Dept-no, Employee-name, Salary)
DEPT (Dept-no, Dept-name, Location)
Write an SQL query to:
(a) Find al...
GATE CSE 1998
Suppose we have a database consisting of the following three relations.
FREQUENTS (student, parlor) giving the parlors each student visits.
SERVES (pa...