Multiple choice

A SELECT statement can be used to perform these three functions: Choose rows from a table Choose columns from a table Bring together data that is stored in different tables by creating a link between them

Which set of keywords describes the above capabilities?

  1. Difference, projection, join

  2. Selection, projection, join

  3. Selection, intersection, join

  4. Intersection, projection, join

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SQL's SELECT statement implements the three fundamental relational operations: selection (choosing rows based on conditions via WHERE), projection (choosing columns via SELECT), and join (combining data from multiple tables via JOIN). Difference and intersection are other set operations, not the primary SELECT operations described.