1Z0-007 · Question #105
A SELECT statement can be used to perform these three functions: 1. Choose rows from a table. 2. Choose columns from a table 3. Bring together data that is stored in different tables by creating a…
The correct answer is B. selection, projection, join. choose rows from a table is SELECTION, Choose column from a table is PROJECTION Bring together data in different table by creating a link between them is JOIN. Incorrect answer: A answer should have SELECTION, PROJECTION and JOIN. C answer should have SELECTION, PROJECTION and…
Question
Options
- Adifference, projection, join
- Bselection, projection, join
- Cselection, intersection, join
- Dintersection, projection, join
- Edifference, projection, product
How the community answered
(21 responses)- A5% (1)
- B76% (16)
- C14% (3)
- E5% (1)
Explanation
choose rows from a table is SELECTION, Choose column from a table is PROJECTION Bring together data in different table by creating a link between them is JOIN. Incorrect answer: A answer should have SELECTION, PROJECTION and JOIN. C answer should have SELECTION, PROJECTION and JOIN. D answer should have SELECTION, PROJECTION and JOIN. E answer should have SELECTION, PROJECTION and JOIN.
Topics
Community Discussion
4
Ingrid P.Jun 26, 2026The correct answer is B, selection, projection, join. Selection is the relational operation that filters rows based on a condition, which maps directly to choosing rows from a table via a WHERE clause. Projection is the operation that returns only specified columns, which is exactly what happens when you name columns in your SELECT list instead of using star. Join is the operation that combines data from two or more tables by matching on a related column, making it the third capability described. These three terms come straight from relational algebra, and the 1Z0-007 exam expects you to know them cold, so put all three on a card with their definitions and quiz yourself until the association is automatic.
Lena V.Jun 25, 2026Selection filters rows, projection filters columns, join links tables. B.
Orla P.Jun 26, 2026Selection filters rows, intersection links sets, join ties tables, C locks it.
Ingrid P.Jun 27, 2026Orla, the answer is B here, because intersection in relational algebra restricts results to rows that appear in both relations, which is the operation being described. The mnemonic locks onto C but the definition you wrote for intersection already points you to B.