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

Easy coding questions

Tough level questions , needed high level of thinking

Q1. Details about the projects in your resume
Add your answer
Q2. MYSQL codes in window function
Ans. 
MYSQL window functions allow for calculations across rows in a result set.
• Window functions are used to perform calculations across rows in a result set

• They are used with the OVER() clause

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()

• They can be used to calculate running totals, moving averages, and more
Answered by AI
Add your answer
Q3. Mostly questions related to cricket tables which was told to be assumed
Add your answer

Link list program, few objective based on cpp

Q1. Good Core knowledge cpp
Add your answer
Q2. Pointer, static , constant used in multiple scenario. Oops, STL
Add your answer

Q1. Basic question about qualification about experience suitable for role or not
Add your answer

Q1. Oops concepts should be strong.
Add your answer
Q2. Strong knowledge with c#
Add your answer
Q3. Asp .net, MVC, web APIs, .net core .
Add your answer

Q1. Senior lead will take this round and deep knowledge of technology
Add your answer

Q1. Manager round with skills and experience
Add your answer

Q1. International call one to one
Add your answer

Q1. Final discussion for salary and all
Add your answer

MCQ based on programming, 2 programming problems

Q1. What is copy constructor ?
Ans. 
Copy constructor is a special constructor that creates a new object by copying an existing object.
• It is used to initialize an object with another object of the same class.

• It takes a reference to an object of the same class as an argument.

• It creates a new object with the same values as the object passed as argument.

• It is automatically called when a new object is created from an existing object.

• Example: MyClass obj1; MyC
Answered by AI
Add your answer
Q2. What is shallow copy and deep copy ?
Ans. 
Shallow copy creates a new object with the same reference as the original, while deep copy creates a new object with a new reference.
• Shallow copy only copies the top-level object, while deep copy copies all nested objects.

• Shallow copy is faster and uses less memory, while deep copy is slower and uses more memory.

• Examples of shallow copy include copying arrays and objects using the spread operator, while examples of dee...read more
Answered by AI
Add your answer
Q3. Implement Merge Sort on an array
Ans. 
Implementation of Merge Sort on an array
• Divide the array into two halves

• Recursively sort the two halves

• Merge the sorted halves

• Time complexity: O(n log n)

• Space complexity: O(n)
Answered by AI
Add your answer
Q4. What are Virtual Functions ?
Ans. 
Virtual functions are functions that can be overridden by derived classes.
• Virtual functions are declared in a base class and can be overridden in derived classes.

• They allow for polymorphism, where a derived class object can be treated as a base class object.

• Virtual functions are called based on the actual object type, not the pointer or reference type.

• They are declared using the virtual keyword in the base class and ca...read more
Answered by AI
Add your answer
Q5. What are you good at in C++ ?
Ans. 
I am good at object-oriented programming, data structures, and algorithms in C++.
• Strong understanding of object-oriented programming principles

• Proficient in implementing data structures and algorithms in C++

• Experience with memory management and pointers

• Familiarity with C++ standard library and STL

• Ability to optimize code for performance and efficiency
Answered by AI
View 1 more answer

Q1. Why do you want to get this job ?
Ans. 
I am passionate about software development and this job aligns perfectly with my skills and interests.
• I have a strong passion for software development and enjoy solving complex problems.

• This job offers the opportunity to work on cutting-edge technologies and contribute to innovative projects.

• I am excited about the company's mission and values, and believe in the positive impact software can have on society.

• I am eager t...read more
Answered by AI
Add your answer
Q2. How long will you stay in this company ?
Ans. 
I am committed to staying with the company for the long term and contributing to its success.
• I am looking for a stable and challenging work environment.

• I believe in the company's mission and values.

• I am eager to grow and develop my skills within the company.

• I am open to new opportunities and challenges that may arise.

• I am committed to building strong relationships with my colleagues and contributing to a positive work
Answered by AI
Add your answer