Mobile Premier League Data Science Intern Interview Questions and Answers

Q1. What is the difference between Union and Union all ?
Ans. 
Union combines the results of two or more SELECT statements, while Union all includes all rows, including duplicates.
• Union removes duplicate rows from the result set, while Union all includes all rows.

• Union sorts the result set, while Union all does not.

• Union is slower than Union all because it performs a distinct operation.

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FRO
Answered by AI
Add your answer
Q2. Which query is more faster , joins or union?
Ans. 
Joins are generally faster than unions.
• Joins are typically faster than unions because they combine data from multiple tables based on a common column, while unions combine data from multiple queries into a single result set.

• Joins can utilize indexes on the columns being joined, which can improve performance.

• Unions involve combining the results of multiple queries, which can be slower as it requires merging and sorting ...read more
Answered by AI
Add your answer

Q1. What is an API (Application Programming Interface)?
Ans. 
An API is a set of rules that allows different software applications to communicate with each other.
• APIs enable integration between different systems, like a weather app using a weather service API.

• They can be RESTful or SOAP, with REST being more common in web services.

• APIs can return data in formats like JSON or XML.

• Examples include social media APIs (e.g., Twitter API) for accessing user data.
Answered by AI
Add your answer
Q2. What is the difference between abstract class and interface?
Ans. 
Abstract classes can have implementation; interfaces cannot. Both define contracts for classes but differ in flexibility and usage.
• An abstract class can have both abstract methods (without implementation) and concrete methods (with implementation).

• An interface can only declare methods (abstract) and cannot provide any implementation.

• A class can inherit from only one abstract class (single inheritance), but it can imple...read more
Answered by AI
Add your answer

Contained aptitude test with both numericals as well as coding questions

It was a one on one round

Q1. Final discussion
Add your answer
Q2. If ready to relocate
Ans. 
Yes, I am open to relocation for the right opportunity.
• I am willing to relocate for a job that aligns with my career goals and offers growth opportunities.

• I am open to exploring new cities and cultures.

• I understand that relocation may come with some challenges, but I am prepared to face them.

• I am excited about the prospect of working with a new team and contributing to the success of the company.
Answered by AI
Add your answer

SQL Coding Test - asked 5 queries related to joins, ranks, group by

Asked guesstimates, technical CV Question, case

Asked guesstimate, market entry question, case

Q1. Resume based questions on past experience
Add your answer
Q2. Case study based questions
Add your answer

Q1. Resume based questions,
Add your answer
Q2. Moderate SQL Coding question
Add your answer
Q3. Case study based questions
Add your answer

Q1. General HR related questions
Add your answer

Q1. Managerial & Aptitude questions
Add your answer

Q1. Managerial discussion about role & industry
Add your answer

General coding questions

Q1. Related technical question
Add your answer