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

No tags found

Unique Visitor Count

Total Unique Visitors

Loading......

Question Options

Contributed by: