Question 10551 – Database-Management-System
February 13, 2024Question 9876 – Database-Management-System
February 13, 2024Question 9831 – Database-Management-System
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 (σ, π, ×, ⋈, ∪, ∩, -)?
Correct Answer: C
Question 38 Explanation:
The sum of all employee’s salaries can’t be represented by using the given six basic algebra operation. If we want to represent sum of salaries then we need to use aggregation operator.
Department address of every employee
Employees whose name is the same as their department name
The sum of all employees’ salaries
All employees of a given department
Subscribe
Login
0 Comments