Fyn Mobility Data Analyst Interview Questions and Answers

Q1. Explain Joins in SQL?
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL 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

• ...read more
Answered by AI
Add your answer
Q2. What is Normalisation?
Ans. 
Normalisation is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalisation involves breaking down data into smaller, more manageable tables

• It helps in reducing data redundancy by storing data in a structured way

• It improves data integrity by ensuring that each piece of data is stored in only one place

• Normalization is usually done in multiple stages (1NF, 2NF, 3NF, etc.) t...read more
Answered by AI
Add your answer

Questions mostly revolved around pandas and numpy.