Multiple choice

Which of the following SQL SELECT statement clauses is an example of the selection capability, but not the joining capability?

  1. WHERE d.deptno = 10

  2. SELECT *

  3. WHERE d.deptno = e.deptno

  4. SELECT id_number, description, cost
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Selection refers to filtering rows based on conditions. WHERE d.deptno = 10 selects only rows where deptno equals 10 - this is pure selection. WHERE d.deptno = e.deptno is joining (relating two tables). SELECT * and SELECT id_number... are projection operations (choosing columns), not selection.

Keep practicing — related questions