Virtual Gate Test Series

Question

The following TRC query represents ____________.

{E ∈ employee (T.ename = E.ename ^ E.salary > 5000)}

(A) Find all employees of salary above 5000
(B) Find names of all employees of salary above 5000
(C) Find salaries of all employees of salary above 5000
(D) Find name and salary of employees of salary above 5000

Comments

Option B must be correct choice.

---

How?

---

Actually the TRC Query should be

{T | E ∈ employee (T.ename = E.ename ^ E.salary > 5000)}

Then it will select only names from employee tables, when their salary is >5000

---

Yes if TRC would have been

{T | E ∈ employee (T.ename = E.ename ^ E.salary > 5000)}

Then indeed it would have select only names from employee tables, when their salary is >5000)}

But according to actual TRC how can we say that it will select only the names of the employee.