GATE 1999
December 7, 2023Question 8670 – Database-Management-System
December 7, 2023Database-Management-System
|
Question 5
|
The following relation records the age of 500 employees of a company, where empNo (indicating the employee number) is the key:
empAge (empNo, age)
Consider the following relational algebra expression:
What does the above expression generate?
empAge (empNo, age)
Consider the following relational algebra expression:
What does the above expression generate?
|
Employee numbers of all employees whose age is not the maximum.
|
|
|
Employee numbers of only those employees whose age is the maximum.
|
|
|
Employee numbers of all employees whose age is not the minimum.
|
|
|
Employee numbers of only those employees whose age is more than the age of exactly one other employee.
|
Question 5 Explanation:
The given relational algebra expression will result in employees whose age is not minimum. The
given conditional join, joins the relations if the age is greater than any of the ages mentioned in the database.
given conditional join, joins the relations if the age is greater than any of the ages mentioned in the database.
Correct Answer: C
Question 5 Explanation:
The given relational algebra expression will result in employees whose age is not minimum. The
given conditional join, joins the relations if the age is greater than any of the ages mentioned in the database.
given conditional join, joins the relations if the age is greater than any of the ages mentioned in the database.
Subscribe
Login
0 Comments