Massive Mobility 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.

Q1. React and redux and more of frnd end
Add your answer

Q1. Give a brief Introduction
Add your answer

Basic python, sql and pandas questions

Q1. Case study (Probability questions)
Add your answer
Q2. Resume projects
Add your answer

Test was based on arrays and some dsa concepts.

Q1. What is your job role
Ans. 
I am responsible for assisting in various tasks and projects within the company.
• Supporting team members in daily operations

• Completing assigned tasks in a timely manner

• Assisting in research and analysis

• Participating in meetings and discussions
Answered by AI
Add your answer
Q2. What is the ctc
Ans. 
CTC stands for Cost to Company, which includes all expenses related to an employee's compensation.
• CTC includes salary, bonuses, benefits, and any other perks provided by the company

• It is the total amount of money a company spends on an employee in a year

• CTC is often used to negotiate job offers and understand the full value of a compensation package
Answered by AI
Add your answer

It was about common analytics concepts

Q1. How many red cars estimate in bangalore
Ans. 
It is impossible to accurately estimate the number of red cars in Bangalore without specific data.
• Estimating the number of red cars in Bangalore would require access to vehicle registration data, which is not readily available.

• Factors such as the total number of cars in Bangalore, the percentage of red cars among them, and the distribution of red cars across the city would need to be considered.

• One could potentially co...read more
Answered by AI
Add your answer
Q2. What will be approach to estimate next year revenue
Ans. 
To estimate next year revenue, I would analyze historical data, market trends, and potential growth opportunities.
• Analyze historical revenue data to identify patterns and trends

• Consider market trends and economic indicators that may impact revenue

• Evaluate potential growth opportunities such as new product launches or market expansions

• Use forecasting techniques such as regression analysis or time series analysis

• Consult ...read more
Answered by AI
Add your answer