SQL Queries and Integrity Constraints: GATE CS previous year questions (Databases)

GATE CS 2025 Set 1NAT2 marksEasy (estimate)
GATE CS 2025 Set 1, Q.55
Consider the following database tables of a sports league. player(pid,pname,age) coach(cid,cname) team(tid,tname,city,cid) members(pid,tid) An instance of the table and...
SQL Queries and Integrity Constraints
GATE CS 2025 Set 2MSQ2 marksEasy (estimate)
GATE CS 2025 Set 2, Q.54
Consider the following relational schema: Students (rollno: integer, name: string, age: integer, cgpa: real) Courses (courseno: integer, cname: string, credits: integer)…
SQL Queries and Integrity Constraints
GATE CS 2023NAT2 marksEasy (estimate)
GATE CS 2023, Q.61
Consider the following table named Student in a relational database. The primary key of this table is rollNum. rollNum name gender marks 1 Naman M 62 2 Aliya F 70 3 Aliya F 80 4...
SQL Queries and Integrity Constraints
GATE CS 2022NAT2 marksMedium (estimate)
GATE CS 2022, Q.56
Consider the relational database with the following four schemas and their respective instances. Student(sNo, sName, dNo), Dept(dNo, dName), Course(cNo, cName, dNo), Register(sN...
SQL Queries and Integrity Constraints
GATE CS 2021 Set 2MCQ2 marksEasy (estimate)
GATE CS 2021 Set 2, Q.41 (CS Q.31)
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 department to which the employ...
SQL Queries and Integrity Constraints
GATE CS 2020MCQ1 markMedium (estimate)
GATE CS 2020, Q.23 (CS Q.13)
Consider a relational database containing the following schemas. sno pno cost S1 P1 150 S1 P2 50 S1 P3 100 S2 P4 200 S2 P5 250 S3 P1 250 S3 P2 150 S3 P5 300 S3 P4 250 sno sname...
SQL Queries and Integrity Constraints
GATE CS 2019NAT2 marksMedium (estimate)
GATE CS 2019, Q.61 (CS Q.51)
A relational database contains two tables Student and Performance as shown below: Student | Roll_no. | Student_name | | :--- | :--- | | 1 | Amit | | 2 | Priya | | 3 | Vi...
SQL Queries and Integrity Constraints
GATE CS 2017 Set 1NAT1 markMedium (estimate)
GATE CS 2017 Set 1, Q.23 (CS Q.23)
Consider a database that has the relation schema $EMP (EmpId, EmpName, DeptName)$ . An instance of the schema EMP and a SQL query on it are given below...
SQL Queries and Integrity Constraints
GATE CS 2017 Set 2NAT1 markMedium (estimate)
GATE CS 2017 Set 2, Q.19 (CS Q.19)
Consider the following tables T1 and T2. Table T1 | P | Q | | :-: | :-: | | 2 | 2 | | 3 | 8 | | 7 | 3 | | 5 | 8 | | 6 | 9 | | 8 | 5 | | 9 | 8 | Table T2 | R | S | | :-:...
ER Model and Relational Schema Design · SQL Queries and Integrity Constraints
GATE CS 2017 Set 2NAT2 marksMedium (estimate)
GATE CS 2017 Set 2, Q.46 (CS Q.46)
Consider the following database table named top_scorer. | player | country | goals | | :--- | :--- | :---: | | Klose | Germany | 16 | | Ronaldo | Brazil | 15 | | G Müller | Ge...
SQL Queries and Integrity Constraints
GATE CS 2016 Set 2NAT2 marksEasy (estimate)
GATE CS 2016 Set 2, Q.62 (CS Q.52)
Consider the following database table named water_schemes: scheme_no | district_name | capacity 1 | Ajmer | 20 1 | Bikaner | 10 2 | Bikaner | 10 3 | Bikaner | 20 1 | Churu | 1...
SQL Queries and Integrity Constraints
GATE CS 2015 Set 1MCQ1 markEasy (estimate)
GATE CS 2015 Set 1, Q.17 (CS Q.7)
SELECT operation in SQL is equivalent to:
SQL Queries and Integrity Constraints
GATE CS 2015 Set 1NAT2 marksEasy (estimate)
GATE CS 2015 Set 1, Q.37 (CS Q.27)
Consider the following relations: Student | Roll No | Student Name | | :---: | :---: | | 1 | Raj | | 2 | Rohit | | 3 | Raj | Performance | Roll No | Course | Marks | | :...
SQL Queries and Integrity Constraints
GATE CS 2015 Set 3MCQ1 markEasy (estimate)
GATE CS 2015 Set 3, Q.13 (CS Q.3)
Consider the following relation $Cinema (theater, address, capacity)$ Which of the following options will be needed at the end of the SQL query ...
SQL Queries and Integrity Constraints · Relational Algebra and Tuple Relational Calculus
GATE CS 2014 Set 1MCQ1 markMedium (estimate)
GATE CS 2014 Set 1, Q.32 (CS Q.22)
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,b,c) where a and b together...
SQL Queries and Integrity Constraints
GATE CS 2014 Set 1MCQ2 marksMedium (estimate)
GATE CS 2014 Set 1, Q.64 (CS Q.54)
Given the following schema: employees(emp-id, first-name, last-name, hire-date, dept-id, salary) departments(dept-id, dept-name, manager-id, location-id) You want to...
SQL Queries and Integrity Constraints
GATE CS 2014 Set 2MCQ2 marksMedium (estimate)
GATE CS 2014 Set 2, Q.64 (CS Q.54)
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...
SQL Queries and Integrity Constraints
GATE CS 2014 Set 3MCQ2 marksEasy (estimate)
GATE CS 2014 Set 3, Q.64 (CS Q.54)
Consider the following relational schema: employee(empId, empName, empDept) customer(custId, custName, salesRepId, rating) salesRepId is a foreign key referring to e...
SQL Queries and Integrity Constraints
GATE CS 2012MCQ1 markMedium (estimate)
GATE CS 2012, Q.15 (CS Q.15)
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 $Q$ : An SQL query can con...
SQL Queries and Integrity Constraints
GATE CS 2012MCQ2 marksMedium (estimate)
GATE CS 2012, Q.51 (CS Q.51)
How many tuples does the result of the following SQL query contain? SELECT A.Id FROM A WHERE A.Age > ALL (SELECT B.Age FROM B WHERE B.Name = 'Arun')
SQL Queries and Integrity Constraints
GATE CS 2011MCQ2 marksMedium (estimate)
GATE CS 2011, Q.32 (CS Q.32)
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 inserted in the table. Let…
SQL Queries and Integrity Constraints
GATE CS 2011MCQ2 marksEasy (estimate)
GATE CS 2011, Q.46 (CS Q.46)
Database table by name Loan_Records is given below. Borrower Bank_Manager Loan_Amount Ramesh Sunderajan 10000.00 Suresh Ramgopal 5000.00 Mahesh Sunderajan 7000.00 What is the...
SQL Queries and Integrity Constraints

Questions

Other topics of Databases