Relational Algebra and Tuple Relational Calculus: GATE CS previous year questions (Databases)

GATE CS 2026 Set 1MCQ2 marksEasy (estimate)
GATE CS 2026 Set 1, Q.43
Consider a relational database schema with two relations $R (P, Q)$ and $S (X, Y)$ . Let…
Relational Algebra and Tuple Relational Calculus
GATE CS 2025 Set 1MCQ2 marksEasy (estimate)
GATE CS 2025 Set 1, Q.39
Consider two relations describing $teams$ and $players$ in a sports league: $teams (tid, tname)$ : $tid, tname$ are...
Relational Algebra and Tuple Relational Calculus
GATE CS 2024 Set 1NAT1 markEasy (estimate)
GATE CS 2024 Set 1, Q.35
Consider the following two relations, $R (A, B)$ and $S (A, C)$ : R.A R.B 10 20 20 30 30 40 30 50 50 95 S.A S.C 10 90 30 45 40 80 The total number of tuples obtained by evaluating th...
Relational Algebra and Tuple Relational Calculus
GATE CS 2024 Set 2MCQ2 marksMedium (estimate)
GATE CS 2024 Set 2, Q.45
The relation schema, Person(pid,city), describes the city of residence for every person uniquely identified by pid. The following relational algebra operators are available:...
Relational Algebra and Tuple Relational Calculus
GATE CS 2022MSQ1 markMedium (estimate)
GATE CS 2022, Q.25
Consider the following three relations in a relational database.…
Relational Algebra and Tuple Relational Calculus
GATE CS 2021 Set 1NAT1 markMedium (estimate)
GATE CS 2021 Set 1, Q.33 (CS Q.23)
A relation $r (A, B)$ in a relational database has 1200 tuples. The attribute $A$ has integer values ranging from 6 to 20, and the attribute $B$ has integer values ranging from 1...
Relational Algebra and Tuple Relational Calculus
GATE CS 2021 Set 1MCQ2 marksMedium (estimate)
GATE CS 2021 Set 1, Q.37 (CS Q.27)
The following relation records the age of 500 employees of a company, where empNo (indicating the employee number) is the key: $empAge (empNo, age)$ Consid...
Relational Algebra and Tuple Relational Calculus
GATE CS 2019NAT2 marksMedium (estimate)
GATE CS 2019, Q.65 (CS Q.55)
Consider the following relations $P (X, Y, Z)$ , $Q (X, Y, T)$ and $R (Y, V)$ : P | X | Y | Z | | :--- | :--- | :--- | | X1 | Y1 | Z1 | | X1 | Y1 | Z2 | | X2 | Y2 | Z2 | | X2 | Y...
Relational Algebra and Tuple Relational Calculus
GATE CS 2018MCQ1 markEasy (estimate)
GATE CS 2018, Q.22 (CS Q.12)
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 = S...
Relational Algebra and Tuple Relational Calculus
GATE CS 2018MCQ2 marksMedium (estimate)
GATE CS 2018, Q.51 (CS Q.41)
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 : r ⋈ (σ_{B < 5} (s))$ ...
Relational Algebra and Tuple Relational Calculus
GATE CS 2017 Set 1MCQ2 marksHard (estimate)
GATE CS 2017 Set 1, Q.41 (CS Q.41)
Consider a database that has the relation schemas EMP(EmpId, EmpName, DeptId), and DEPT(DeptName, DeptId). Note that the DeptId can be permitted to be NULL in the relation EMP....
Relational Algebra and Tuple Relational Calculus
GATE CS 2017 Set 1NAT2 marksMedium (estimate)
GATE CS 2017 Set 1, Q.46 (CS Q.46)
Consider a database that has the relation schema $CR (StudentName, CourseName)$ . An instance of the schema CR is as given below. StudentName CourseName SA CA...
Relational Algebra and Tuple Relational Calculus
GATE CS 2015 Set 2MCQ2 marksEasy (estimate)
GATE CS 2015 Set 2, Q.42 (CS Q.32)
Consider two relations $R_{1} (A, B)$ with the tuples $(1, 5), (3, 7)$ and $R_{2} (A, C)$ with $(1, 7), (4, 9)$ . Assume that $R (A, B, C)$ is the full natural outer join of $R_{1}$ and…
Relational Algebra and Tuple Relational Calculus
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 3MCQ1 markEasy (estimate)
GATE CS 2014 Set 3, Q.31 (CS Q.21)
What is the optimized version of the relation algebra expression $π_{A 1} (π_{A 2} (σ_{F 1} (σ_{F 2} (r))))$ , where $A 1, A 2$ are sets of attributes in $r$ with…
Relational Algebra and Tuple Relational Calculus
GATE CS 2014 Set 3MCQ2 marksMedium (estimate)
GATE CS 2014 Set 3, Q.40 (CS Q.30)
Consider the relational schema given below, where eId of the relation dependent is a foreign key referring to empId of the relation employee. Assume that every employee has at l...
Relational Algebra and Tuple Relational Calculus
GATE CS 2013MCQ2 marksMedium (estimate)
GATE CS 2013, Q.35 (CS Q.35)
Consider the following relational schema. $Students (rollno : integer, sname : string)$ …
Relational Algebra and Tuple Relational Calculus
GATE CS 2012MCQ1 markEasy (estimate)
GATE CS 2012, Q.14 (CS Q.14)
Given the basic ER and relational models, which of the following is INCORRECT?
Relational Algebra and Tuple Relational Calculus · ER Model and Relational Schema Design
GATE CS 2012MCQ2 marksEasy (estimate)
GATE CS 2012, Q.43 (CS Q.43)
Suppose $R_{1} (A, B)$ and $R_{2} (C, D)$ are two relation schemas. Let $r_{1}$ and $r_{2}$ be the corresponding relation instances. $B$ is a foreign key that refers to $C$ in $R_{2}$ . If d...
Relational Algebra and Tuple Relational Calculus · Relational Algebra and Tuple Relational Calculus
GATE CS 2012MCQ2 marksMedium (estimate)
GATE CS 2012, Q.50 (CS Q.50)
How many tuples does the result of the following relational algebra expression contain? Assume that the schema of $A \cup B$ is the same as that of $A$ .…
Relational Algebra and Tuple Relational Calculus

Questions

Other topics of Databases