ExamSIDE
Questions
ExamSIDE.Com
Database Management System
Structured Query Language
Transactions and Concurrency
Functional Dependencies and Normalization
Relational Algebra
File Structures and Indexing
Er Diagrams
Joint Entrance Examination
JEE Main
Chemistry
Physics
Mathematics
JEE Advanced
Physics
Chemistry
Mathematics
WB JEE
Physics
Chemistry
Mathematics
Graduate Aptitude Test in Engineering
GATE CSE
Theory of Computation
Operating Systems
Algorithms
Digital Logic
Database Management System
Data Structures
Computer Networks
Software Engineering
Compiler Design
Web Technologies
General Aptitude
Discrete Mathematics
Programming Languages
Computer Organization
GATE ECE
Network Theory
Control Systems
Electronic Devices and VLSI
Analog Circuits
Digital Circuits
Microprocessors
Signals and Systems
Communications
Electromagnetics
General Aptitude
Engineering Mathematics
GATE EE
Electromagnetic Fields
Signals and Systems
Engineering Mathematics
General Aptitude
Power Electronics
Power System Analysis
Analog Electronics
Control Systems
Digital Electronics
Electrical Machines
Electric Circuits
Electrical and Electronics Measurement
GATE ME
Engineering Mechanics
Strength of Materials
Theory of Machines
Engineering Mathematics
Machine Design
Fluid Mechanics
Turbo Machinery
Heat Transfer
Thermodynamics
Production Engineering
Industrial Engineering
General Aptitude
GATE CE
Engineering Mechanics
Strength of Materials Or Solid Mechanics
Structural Analysis
Construction Material and Management
Reinforced Cement Concrete
Steel Structures
Geotechnical Engineering
Fluid Mechanics and Hydraulic Machines
Hydrology
Irrigation
Geomatics Engineering Or Surveying
Environmental Engineering
Transportation Engineering
Engineering Mathematics
General Aptitude
GATE PI
Fluid Mechanics
Metrology
Theory of Machines
Engineering Mathematics
Heat Transfer
Machine Tools and Machining
Industrial Engineering
Engineering Mechanics
Strength of Materials
Thermodynamics
Machine Design
Casting
Joining of Materials
Metal Forming
GATE IN
Engineering Mathematics
Medical
NEET
Biology
Chemistry
Physics
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
Relational Algebra
Database Management System
Previous Years Questions
START HERE
Marks 1
More
Consider the following three relations in a relational database. Employee ( $$\underline {eld} $$ , Name), Brand ( $$\un...
GATE CSE 2022
GO TO QUESTION
What is the optimized version of the relation algebra expression $$\pi_{A1}(\pi_{A2}(\sigma_{F1}(\sigma_{F2}(r))))$$, wh...
GATE CSE 2014 Set 3
GO TO QUESTION
Which of the following tuple relational calculus expression(s) is/are equivalent to $$\forall t \in r \left(P\left(t\rig...
GATE CSE 2008
GO TO QUESTION
Which of the following relational query languages have the same expressive power? I) Relational algebra II) Tuple relati...
GATE CSE 2006
GO TO QUESTION
Consider the relations r1(P, Q, R) and r2(R, S, T) with primary keys P and R respectively. The relation r1 contains 2000...
GATE CSE 2006
GO TO QUESTION
Let r be a relation instance with schema R = (A, B, C, D). We define $${r_1} = {\pi _{A,B,C}}\left( r \right)$$ and $${r...
GATE CSE 2005
GO TO QUESTION
Let R1 (A, B, C) and R2 (D, E) be two relation schema, where the primary keys are shown underlined, and let C be a forei...
GATE CSE 2004
GO TO QUESTION
Consider the following SQL query: Select distinct a1, a2, ..., an From r1, r2, ..., rm Where P; For an arbitrary p...
GATE CSE 2003
GO TO QUESTION
With regard to the expressive power of the formal relational query languages, which of the following statements is true?
GATE CSE 2002
GO TO QUESTION
Given the relations employee (name, salary, deptno), and department (deptno, deptname, address) Which of the following...
GATE CSE 2000
GO TO QUESTION
The relational algebra expression equivalent to the following tuple calculus expression: $$\left\{ {t|t \in r \wedge \le...
GATE CSE 1999
GO TO QUESTION
Consider the join of a relation R with a relation S. If R has m tuples and S has n tuples then the maximum and minimum s...
GATE CSE 1999
GO TO QUESTION
An instance of a relational scheme R(A, B, C) has distinct values for attribute A. Can you conclude that A is a candidat...
GATE CSE 1994
GO TO QUESTION
Give a relational algebra expression using only the minimum number of operators from $$\left( { \cup ,\, - } \right)$$ w...
GATE CSE 1994
GO TO QUESTION
Marks 2
More
A relation r(A, B) in a relational database has 1200 tuples. The attribute A has integer values ranging from 6 to 20, an...
GATE CSE 2021 Set 1
GO TO QUESTION
Consider the following relations P(X,Y,Z), Q(X,Y,T) and R(Y,V). How many tuples will be returned by the following relat...
GATE CSE 2019
GO TO QUESTION
Consider the relations $$r(A, B)$$ and $$s(B, C),$$ where $$s.B$$ is a primary key and $$r.B$$ is a foreign key referenc...
GATE CSE 2018
GO TO QUESTION
Consider two relations $${R_1}\left( {A,B} \right)$$ with the tuples $$(1,5), (3,7)$$ and $${R_2}\left( {A,C} \right) = ...
GATE CSE 2015 Set 2
GO TO QUESTION
Consider the relational schema given below, where eId of the relation dependent is a foreign key referring to empId of t...
GATE CSE 2014 Set 3
GO TO QUESTION
Consider a join (relation algebra) between relations r(R)and s(S) using the nested loop method. There are 3 buffers each...
GATE CSE 2014 Set 2
GO TO QUESTION
Consider the following relations A, B and C: A .tg {border-collapse:collapse;border-spacing:0;} .tg td{font-family:Ari...
GATE CSE 2012
GO TO QUESTION
Consider the following relations A, B and C: A .tg {border-collapse:collapse;border-spacing:0;} .tg td{font-family:Ari...
GATE CSE 2012
GO TO QUESTION
Suppose R1 (A, B) and R2 (C, D) are two relation schemas. Let r1 and r2 be the corresponding relation instances. B is a ...
GATE CSE 2012
GO TO QUESTION
Consider a relational table r with sufficient number of records, having attributes A1, A2,....., An and let 1 $$ \le $$ ...
GATE CSE 2011
GO TO QUESTION
The following functional dependencies hold for relations R(A, B, C) and S(B, D, E): $$$\eqalign{ & B \to A \cr ...
GATE CSE 2010
GO TO QUESTION
Let R and S be two relations with the following schema R (P, Q, R1, R2, R3) S (P, Q, S1, S2) Where {P, Q} is the key for...
GATE CSE 2008
GO TO QUESTION
Consider the following relation schemas : b-Schema = (b-name, b-city, assets) a-Schema = (a-num, b-name, bal) d-Schema =...
GATE CSE 2007
GO TO QUESTION
Consider the relation employee(name, sex, supervisorName) with name as the key, supervisorName gives the name of the sup...
GATE CSE 2007
GO TO QUESTION
Consider a selection of the form σA ≤ 100(r), where r is a relation with 1000 tuples. Assume that the attribute values f...
GATE CSE 2007
GO TO QUESTION
Information about a collection of students is given by the relation studInfo(studId, name, sex). The relation enroll(stu...
GATE CSE 2007
GO TO QUESTION
A table ‘student’ with schema (roll, name, hostel, marks), and another table ‘hobby’ with schema (roll, hobbyname) conta...
GATE CSE 2005
GO TO QUESTION
Consider the relation Student (name, sex, marks), where the primary key is shown underlined, pertaining to students in a...
GATE CSE 2004
GO TO QUESTION
Which of the following relational calculus expressions is not safe?
GATE CSE 2001
GO TO QUESTION
Which of the following query transformations (i.e. replacing the l.h.s. expression by the r.h.s. expression) is incorrec...
GATE CSE 1998
GO TO QUESTION
A library relational database system uses the following schema USERS (User #, User Name, Home Town) BOOKS (Books # Book ...
GATE CSE 1996
GO TO QUESTION
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