Mphasis Module Lead Interview Questions, Process, and Tips

Basis data structure and algo

Q1. Basic oops and from java 8
Add your answer
Q2. System design and design principles
Ans. 
System design involves creating a high-level architecture of a software system based on requirements and design principles.
• System design focuses on structuring software components and their interactions.

• Design principles like SOLID, DRY, and KISS help in creating scalable and maintainable systems.

• Consider factors like performance, scalability, security, and maintainability during system design.

• Use design patterns like ...read more
Answered by AI
Add your answer

Q1. Selenium ,etl,java
Add your answer
Q2. Irctc website textbox ,find element. reverse string java program, with space in name
Add your answer
Q3. Fact table and dimension table
Add your answer
Q4. Sql query for update
Ans. 
SQL query for updating data in a database table.
• Use the UPDATE statement in SQL to modify existing records in a table.

• Specify the table name, column names, and values to be updated in the query.

• Use WHERE clause to specify the condition for which records to update.

• Example: UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;
Answered by AI
Add your answer

Q1. What is Indexing in SQL and why do we use Indexing?
Ans. 
Indexing in SQL is a way to optimize database performance by creating a data structure that allows for faster retrieval of data.
• Indexing is a technique used to quickly locate and access the rows in a database table.

• It works by creating an ordered list of values from one or more columns in a table.

• By using indexes, the database engine can quickly find the rows that match a certain condition without having to scan the en...read more
Answered by AI
Add your answer
Q2. What is a recursive query?
Ans. 
A recursive query is a query that refers to itself in order to retrieve data from a database.
• A recursive query is used to retrieve hierarchical data such as organizational structures or family trees.

• It typically involves a common table expression (CTE) in SQL.

• The query continues to execute until a specific condition is met, such as reaching the root node in a tree structure.

• Example: Finding all employees and their mana
Answered by AI
Add your answer
Q3. What are the various joins in SQL?
Ans. 
Various types of joins in SQL include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full outer join: Returns rows when there is a match in either table.
Answered by AI
Add your answer

Q1. Tell me about yourself.
Add your answer

Q1. Salary discussion.
Add your answer

Q1. Every thing in .Net- 1. OOPS 2. C# 3. MVC Life cycle, Filters 4. LINQ. 5. ADO.NET 6. EF 7.MS SQL- SP, JOINS, Indexers, Triggers, Asked to Write Queries using joins, cases.
Add your answer

Q1. Client Round - technical questions, mainly to check basic knowledge about coding - detailed discussion on constructors. Project related, previous work done.
Add your answer

Q1. Basic OOPS questions.
Add your answer

Q1. Questions on Core Java
Add your answer
Q2. Coding question on arrays, leetcode easy level.
Add your answer

Q1. Questions related to Spring boot and other related frameworks
Add your answer
Q2. Questions on microservices and their architectures
Add your answer
Q3. Questions on other backend related technologies
Add your answer

Q1. Salary discussion
Add your answer