Qtr No. 213, New Town Yehlanka Indore 454775
Consider two tables employee and department. Identify proper types of Join to be used for given scenarios.
| Scenarios |
| a. The management would like to know the names of employees and their associated departments. |
| b. The management would like to retrieve all employee and department names irrespective of the department they are associated with. |
| c. The management would like to get a report that displays employee and their corresponding manager details. |
a. => self join
b. => right join
c. => self join
a. => inner join
b. => left join
c. => self join
a. => inner join
b. => right join
c. => self join
a. => inner join
b. => inner join
c. => self join
To get all Infosys Certified PostgreSQL Associate Exam questions Join Group https://bit.ly/infy_premium_group
We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.
Qtr No. 213, New Town Yehlanka Indore 454775
admin@prepflix.in
