1

GATE CSE 2004

MCQ (Single Correct Answer)

+1

-0.3

Let R

_{1}(__A,__B, C) and R_{2}(__D,__E) be two relation schema, where the primary keys are shown underlined, and let C be a foreign key in R_{1}referring to R_{2}. Suppose there is no violation of the above referential integrity constraint in the corresponding relation instances r_{1}and r_{2}. Which one of the following relational algebra expressions would necessarily produce an empty relation?2

GATE CSE 2003

MCQ (Single Correct Answer)

+1

-0.3

Consider the following SQL query:

`Select distinct a`_{1}, a_{2}, ..., a_{n}
From r_{1}, r_{2}, ..., r_{m}
Where P;

For an arbitrary predicate P, this query is equivalent to which of the following relational algebra expressions? 3

GATE CSE 2002

MCQ (Single Correct Answer)

+1

-0.3

With regard to the expressive power of the formal relational query languages, which of the following statements is true?

4

GATE CSE 2000

MCQ (Single Correct Answer)

+1

-0.3

Given the relations

**employee (name, salary, deptno)**, and **department (deptno, deptname, address)**

Questions Asked from Relational Algebra (Marks 1)

Number in Brackets after Paper Indicates No. of Questions

GATE CSE Subjects

Theory of Computation

Operating Systems

Algorithms

Database Management System

Data Structures

Computer Networks

Software Engineering

Compiler Design

Web Technologies

General Aptitude

Discrete Mathematics

Programming Languages