Computer Sciences > GATE 2021 SET-1 > Relational Algebra
The following relation records the age of 500 employees of a company, where empNo (indicating the employee number) is the key:
empAge(empNo, age)
Consider the following relational algebra expression:
ΠempNo(empAge ⋈(age>age1) ρempNo1,age1(empAge))
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.

Correct : c

Similar Questions

Consider a database that has the relation schemas EMP (EmpId, EmpName, DepId), and DEPT(DeptName, DeptId). Note that the DepId can be permitted to be NULL in th...
#198 MCQ
Consider the following two relations, R(A,B) and S(A,C); The total number of tuples obtained by evaluating the following expression σB<C(R ⨝R.A=S.AS) is...
#871 Fill in the Blanks
The relation schema, Person(pid, city), describes the city of residence for every person uniquely identified by pid. The following relational algebra operators...
#930 MCQ

Related Topics

relational algebra expression employee data GATE 2021 empAge relation relational calculus age comparison maximum age minimum age employee number filter GATE computer science 2021

Unique Visitor Count

Total Unique Visitors

Loading......

Question Options

Contributed by: