ITC Infotech Team Lead Interview Questions and Answers

A SQL join is used to combine rows from two or more tables based on a related column between them.

• Use the JOIN keyword to specify the tables to be joined

• Use the ON keyword to specify the column to join on

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

Two common SQL joins are INNER JOIN and LEFT JOIN.

• INNER JOIN: Returns rows when there is at least one match in both tables.

• LEFT JOIN: Returns all rows from the left table and the matched rows from the right table.

Program to concatenate first name and last name and print character and occurrence

• Create a function that takes an array of strings as input

• Concatenate the first name and last name for each string in the array

• Count the occurrence of each character in the concatenated string

• Print the character and its occurrence