Qtr No. 213, New Town Yehlanka
Indore 454775, India
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 Telegram Group https://rebrand.ly/lex-telegram-236dee
