GATE CS 2021 (Forenoon) — Question 37

Database Management Systems (DBMS)Relational Models, Relational Algebra, Tuple CalculusMCQ2 marks · −2/3 if wrongMedium

The following relation records the age of 500 employees of a company, where empNo (indicating the employee number) is the key: empAge(\underline{empNo}, age) Consider the following relational algebra expression: \(\Pi_{\text{empNo}} (\text{empAge} \bowtie_{(\text{age} > \text{age1})} \rho_{\text{empNo1, age1}} (\text{empAge}))\) What does the above expression generate?
  1. A
    Employee numbers of only those employees whose age is the maximum.
  2. B
    Employee numbers of only those employees whose age is more than the age of exactly one other employee.
  3. C
    Employee numbers of all employees whose age is not the minimum.
  4. D
    Employee numbers of all employees whose age is the minimum.
Practise the full 2021-FN paper
Challenge a friend: WhatsApp Telegram
From RENYXERAWhat rank do your marks get?GATE score, likely All-India Rank and qualifying marks for your category.
Practise more on Relational Models, Relational Algebra, Tuple CalculusTimed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group