MCQOPTIONS
Saved Bookmarks
| 1. |
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:IIempNo(empAge ⋈ (age>age1) ρempNo 1, age1(empAge))What does the above expression generate? |
| A. | Employee numbers of only those employees whose age is the maximum. |
| B. | Employee numbers of all employees whose age is not the minimum. |
| C. | Employee numbers of only those employees whose age is more than the age of exactly one other employee. |
| D. | Employee numbers of all employees whose age is the minimum. |
| Answer» C. Employee numbers of only those employees whose age is more than the age of exactly one other employee. | |