which capabilities of a SELECT statement are performed?

Evaluate this SQL statement:
SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME
FROM EMPLOYEES e, DEPARTMENTS d
WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;
In the statement, which capabilities of a SELECT statement are performed?

Evaluate this SQL statement:
SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME
FROM EMPLOYEES e, DEPARTMENTS d
WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;
In the statement, which capabilities of a SELECT statement are performed?

A.
selection, projection, join

B.
selection, intersection, join

C.
intersection, projection, join

D.
difference, projection, product

E.
difference, projection, join

Explanation:

Selection, projection and join capabilities of a SELECT statement are performed in this view.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Oscar

Oscar

What’s “projection”?

sreelatha

sreelatha

projection:retreving columns