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
Recommended book · affiliate linkDatabase System Concepts (Korth)Normalisation, SQL, transactions and indexing — the DBMS syllabus in one book.
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