Related Articles

GATE | GATE CS 2021 | Set 1 | Question 37

• Last Updated : 24 May, 2021

The following relation records the age of 500 employees of a company, where empNo ( indicating the employee number) is the key:

Consider the following relational algebra expression:

What does the above expression generate?
(A) Employee numbers of only those employees whose age is the maximum
(B) Employee numbers of only those employees whose age is more than the age of exactly one other employee
(C) Employee numbers of all employees whose age is not the minimum
(D) Employee numbers of all employees whose age is the minimum

Explanation: In the given query, conditional join is applied between the two relations.

We have a condition in the conditional join that if the age of the employee is greater than age of the any other employee, it will print the empno of that employee.

So above query will print the empno of all the employees whose age is not minimum.

Quiz of this Question

Attention reader! Don’t stop learning now.  Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.

Learn all GATE CS concepts with Free Live Classes on our youtube channel.

My Personal Notes arrow_drop_up