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
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

This SQL performs selection (WHERE clause filters rows), projection (SELECT clause picks specific columns), and join (WHERE clause connects EMP and DEPARTMENT tables). Intersection and Difference are set operations not shown here. The query filters employees, projects only needed columns, and joins related tables.

Keep practicing — related questions