Mphasis Senior Software Engineer Interview Questions, Process, and Tips

Round duration - 60 Minutes
Round difficulty - Medium

This was a technical Interview round where I was asked questions related to DBMS , Spring Boot and basic OOPS concepts in Java.

Q1. How does index hunting help improve query performance?
Ans. 
Index hunting helps improve query performance by reducing the number of rows that need to be scanned.
• Indexes allow the database to quickly locate the rows that satisfy a query criteria.

• By using indexes, the database can avoid scanning the entire table, leading to faster query execution.

• Examples of indexes include primary keys, unique keys, and indexes on frequently queried columns.
Answered by AI
Add your answer
Q2. What is meant by Data Warehousing?
Ans. 
Data Warehousing is the process of collecting, storing, and managing data from various sources for analysis and reporting.
• Data Warehousing involves extracting data from multiple sources

• Data is then transformed and loaded into a central repository

• The data can be queried and analyzed for business intelligence purposes

• Examples include using a data warehouse to analyze sales trends or customer behavior
Answered by AI
Add your answer
Q3. What is the starter dependency of the Spring Boot module?
Ans. 
The starter dependency of the Spring Boot module is spring-boot-starter.
• The starter dependency provides a set of common dependencies for a specific type of application, making it easier to get started with Spring Boot.

• For example, spring-boot-starter-web includes dependencies for building web applications using Spring MVC.

• Other common starter dependencies include spring-boot-starter-data-jpa for JPA data access and spr
Answered by AI
Add your answer
Q4. What is the purpose of using @ComponentScan in class files?
Ans. 
@ComponentScan is used to automatically detect and register Spring components in the classpath.
• Scans the specified package and its sub-packages for classes annotated with @Component, @Repository, @Service, or @Controller

• Registers the detected classes as Spring beans for dependency injection and other Spring features

• Reduces the need for manual bean configuration in the Spring application context

• Can be customized with ba...read more
Answered by AI
Add your answer
Q5. When can you use the super keyword?
Ans. 
The super keyword is used to refer to the parent class in Java.
• Used to call the constructor of the parent class in the child class.

• Used to access the parent class methods and variables.

• Helps in achieving method overriding in inheritance.
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

This round had questions revolving around Selenium , OOPS ans some fundamental concepts related to Java.

Q1. What are the different types of locators in Selenium?
Ans. 
Different types of locators in Selenium include ID, Name, Class Name, Tag Name, Link Text, Partial Link Text, XPath, and CSS Selector.
• ID - Locate elements by their ID attribute

• Name - Locate elements by their Name attribute

• Class Name - Locate elements by their Class attribute

• Tag Name - Locate elements by their HTML tag name

• Link Text - Locate anchor elements by their exact text

• Partial Link Text - Locate anchor elements b...read more
Answered by AI
Add your answer
Q2. What is the garbage collector in Java?
Ans. 
Garbage collector in Java is a built-in mechanism that automatically manages memory by reclaiming unused objects.
• Garbage collector runs in the background to identify and delete objects that are no longer needed.

• It helps prevent memory leaks and optimize memory usage.

• Examples of garbage collectors in Java include Serial, Parallel, CMS, and G1.
Answered by AI
Add your answer
Q3. What is an interface?
Ans. 
An interface in software engineering is a contract that defines the methods that a class must implement.
• Defines a set of methods that a class must implement

• Helps achieve abstraction and loose coupling

• Allows for multiple classes to implement the same interface

• Example: Java interfaces define method signatures that classes must implement
Answered by AI
Add your answer
Q4. What is a classloader in Java?
Ans. 
A classloader in Java is a part of the Java Runtime Environment that dynamically loads Java classes into the Java Virtual Machine.
• Classloaders are responsible for loading classes at runtime based on the fully qualified name of the class.

• There are different types of classloaders in Java such as Bootstrap Classloader, Extension Classloader, and Application Classloader.

• Classloaders follow a delegation model where a classl...read more
Answered by AI
Add your answer
Q5. What do you understand by the Java Virtual Machine?
Ans. 
Java Virtual Machine (JVM) is a virtual machine that enables a computer to run Java programs.
• JVM is responsible for converting Java bytecode into machine code that can be executed by the computer's processor.

• It provides a layer of abstraction between the Java code and the underlying hardware and operating system.

• JVM manages memory, handles garbage collection, and provides security features for Java applications.

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

Round duration - 30 Minutes
Round difficulty - Easy

This was a typical HR round with some standard Behavioral questions.

Q1. Why are you looking for a job change?
Add your answer

Round duration - 40 minutes
Round difficulty - Easy

This was a technical round where I was grilled on questions from DBMS, OS and Springboot. I hadn't gone through OS concepts and couldn't answer those questions.

Q1. 
Trapping Rain Water Problem Statement
Given a long type array/list ARR of size N, representing an elevation map where ARR[i] denotes the elevation of the ith bar, calculate the total amount of rainwater t...read more
Ans. 
Calculate the total amount of rainwater that can be trapped in given elevation map.
• Iterate through the array to find the maximum height on the left and right of each bar.

• Calculate the amount of water that can be trapped above each bar by taking the minimum of the maximum heights on the left and right.

• Sum up the trapped water above each bar to get the total trapped water for the entire elevation map.
Answered by AI
Add your answer