Mphasis Interview Questions, Process, and Tips

Q1. Sql questions on rdbms
Add your answer
Q2. Java questions on ooops
Add your answer

Q1. ReduceByKey vs groupByKey
Ans. 
reduceByKey is more efficient than groupByKey for aggregating data in Spark due to reduced shuffling.
• reduceByKey combines values for each key in each partition before shuffling data

• groupByKey shuffles all data to a single partition before combining values for each key

• reduceByKey is preferred for large datasets to minimize data movement and improve performance
Answered by AI
Add your answer
Q2. Word count in scala
Ans. 
Scala provides a simple way to count words in a string using built-in functions.
• Use the split function to split the string into an array of words

• Use the length function to get the count of words in the array
Answered by AI
Add your answer
Q3. Second highest salary SQL
Ans. 
Use SQL query with ORDER BY and LIMIT to find the second highest salary.
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 1,1 to skip the first highest salary and get the second highest salary
Answered by AI
Add your answer

The round1 was aptitude test it was average level neither easy nor hard

Q1. What is shortest path algo
Ans. 
Shortest path algo is a method to find the most efficient route between two points in a graph or network.
• Shortest path algorithms are used in various applications such as GPS navigation systems, network routing, and logistics planning.

• Examples of shortest path algorithms include Dijkstra's algorithm, Bellman-Ford algorithm, and Floyd-Warshall algorithm.

• These algorithms calculate the shortest path based on different cri...read more
Answered by AI
Add your answer
Q2. What is diff b/w compiler and interpreter
Ans. 
Compiler translates entire code into machine code before execution, while interpreter translates code line by line during execution.
• Compiler converts entire code into machine code before execution

• Interpreter translates code line by line during execution

• Compiler generates intermediate object code or executable file

• Interpreter does not generate intermediate object code

• Examples: C, C++ compilers vs Python, Ruby interprete
Answered by AI
Add your answer
Q3. What are 4 pillars of oops
Ans. 
The 4 pillars of OOP are Inheritance, Encapsulation, Abstraction, and Polymorphism.
• Inheritance allows a class to inherit properties and behavior from another class.

• Encapsulation restricts access to certain components within a class, protecting the data.

• Abstraction hides the complex implementation details and only shows the necessary features.

• Polymorphism allows objects to be treated as instances of their parent class.
Answered by AI
Add your answer

Q1. Tell me about the company
Add your answer
Q2. What is your hobby
Add your answer

Q1. Explain java jvm
Ans. 
Java JVM stands for Java Virtual Machine, which is a virtual machine that enables a computer to run Java programs.
• Java JVM is a virtual machine that interprets Java bytecode and executes it on the underlying hardware.

• It provides platform independence by abstracting the hardware and operating system details.

• JVM manages memory, garbage collection, and runtime environment for Java programs.

• Examples of JVM implementations
Answered by AI
Add your answer
Q2. Explain encapsulation
Ans. 
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit.
• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• It allows for data hiding, which prevents outside code from directly accessing an object's internal state.

• Encapsulation also helps in achieving data abstraction, where the internal details of an object are hidden and only the nec...read more
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What are the events of scrum? How do you carry them out?
Ans. 
The events of Scrum are Sprint, Sprint Planning, Daily Standup, Sprint Review, and Sprint Retrospective.
• Sprint: Time-boxed iteration where work is completed and reviewed.

• Sprint Planning: Meeting to plan the work to be done in the Sprint.

• Daily Standup: Daily meeting for the team to synchronize and plan the day's work.

• Sprint Review: Meeting at the end of the Sprint to review the work completed.

• Sprint Retrospective: Meeti...read more
Answered by AI
Add your answer
Q3. What do you mean by continuous integration?
Ans. 
Continuous integration is the practice of frequently integrating code changes into a shared repository to detect and fix integration errors early.
• Automating the process of building, testing, and integrating code changes multiple times a day

• Helps in identifying and fixing integration errors quickly

• Ensures that the codebase is always in a deployable state

• Promotes collaboration and communication among team members
Answered by AI
Add your answer
Q4. What was a challenge that you faced as scrum master?
Add your answer
Q5. What are the agile metrics you used in your previous project?
Ans. 
Agile metrics used in previous project included velocity, burndown charts, and cycle time.
• Velocity - measuring the amount of work completed in a sprint

• Burndown charts - tracking the remaining work in a sprint

• Cycle time - measuring the time taken for a task to be completed
Answered by AI
Add your answer

Q1. What is Collection, Interface?
Ans. 
Collection is a group of objects, Interface is a contract that defines a set of methods to be implemented.
• Collection is a framework that provides an architecture to store and manipulate a group of objects.

• Interface in Java is a blueprint of a class that defines a set of methods without implementation.

• Example: List, Set, Map are different types of collections in Java. Comparable, Serializable are examples of interfaces.
Answered by AI
Add your answer
Q2. Create the API using Spring boot.
Ans. 
Creating API using Spring Boot for software development.
• Use @RestController annotation to define RESTful web services.

• Define request mappings using @RequestMapping annotation.

• Use @GetMapping, @PostMapping, @PutMapping, @DeleteMapping annotations for specific HTTP methods.

• Use @RequestBody annotation to bind HTTP request body to a method parameter.

• Use @ResponseBody annotation to bind the return value to the HTTP response
Answered by AI
Add your answer