Intellect Data Analyst Interview Questions and Answers

A Left Join is a type of join operation in relational databases that returns all rows from the left table and the matched rows from the right table.

• Returns all rows from the left table, even if there are no matches in the right table

• If there are no matches, NULL values are used for the columns from the right table

• Useful for retrieving data from one table while including any matching data from another table

Concatenate two lists of strings into a single list

• Use the '+' operator to concatenate two lists

• Ensure both lists are arrays of strings before concatenating

• Example: list1 = ['apple', 'banana'], list2 = ['orange', 'grape']

• Concatenated list: ['apple', 'banana', 'orange', 'grape']