Skip to content
Related Articles

Related Articles

GATE | GATE-CS-2000 | Question 23

Improve Article
Save Article
  • Last Updated : 28 Jun, 2021
Improve Article
Save Article

Given the relations

employee (name, salary, deptno) and
department (deptno, deptname, address)

Which of the following queries cannot be expressed using the basic relational algebra operations (U, -, x, \pi, \sigma , p)?
(A) Department address of every employee
(B) Employees whose name is the same as their department name
(C) The sum of all employees’ salaries
(D) All employees of a given department


Answer: (C)

Explanation: See question 1 of https://www.geeksforgeeks.org/database-management-system-set-1/

Quiz of this Question

My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!