Oracle
1Z0-061 · Question #261
Examine the structure of the EMPLOYEES and DEPARTMENTS tables: You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an…
The correct answer is D. SELECT e.last_name, d.department_name, d.location_id. Equijoins are also called simple joins or inner joins. Equijoin involve primary key and foreign key.
Displaying Data from Multiple Tables using Joins
Question
Examine the structure of the EMPLOYEES and DEPARTMENTS tables:
You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?
Exhibit
Options
- ASELECT last_name, department_name, location_id
- BSELECT employees.last_name, departments.department_name, departments.location_id FROM
- CSELECT e.last_name, d.department_name, d.location_id
- DSELECT e.last_name, d.department_name, d.location_id
How the community answered
(52 responses)- A6% (3)
- B10% (5)
- C4% (2)
- D81% (42)
Explanation
Equijoins are also called simple joins or inner joins. Equijoin involve primary key and foreign key.
Topics
#equi-join#table aliases#multi-table SELECT#column qualification
Community Discussion
No community discussion yet for this question.