Multiple choice technology databases

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

  1. Selection, projection, join

  2. Difference, projection, join

  3. Selection, intersection, join

  4. Intersection, projection, join

  5. Difference, projection, product
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

This query performs selection (WHERE clause filters rows), projection (SELECT chooses specific columns), and join (connects EMP and DEPARTMENT tables). These are fundamental SQL capabilities.

Keep practicing — related questions