Open In App
Related Articles

GATE | GATE-CS-2000 | Question 23

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Report issue
Report
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

Last Updated : 28 Jun, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads