Oracle
1Z0-061 · Question #153
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.
Retrieving Data using the SQL SELECT Statement
Question
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 link between them. Which set of keywords describes these capabilities?
Options
- Adifference, projection, join
- Bselection, projection, join
- Cselection, intersection, join
- Dintersection, projection, join
- Edifference, projection, product
How the community answered
(38 responses)- A5% (2)
- B84% (32)
- C8% (3)
- E3% (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.
Topics
#selection#projection#join#SQL capabilities
Community Discussion
No community discussion yet for this question.