Mphasis Interview Questions, Process, and Tips for Experienced

Q1. Define. Net core?
Ans. 
ASP.NET Core is a cross-platform, high-performance framework for building modern, cloud-based, internet-connected applications.
• Cross-platform framework for building web applications

• High-performance and scalable

• Supports cloud-based and internet-connected applications
Answered by AI
Add your answer
Q2. Explain web api?
Ans. 
Web API is a set of rules and protocols that allow different software applications to communicate with each other over the internet.
• Web API stands for Application Programming Interface for web-based systems.

• It allows different software applications to interact with each other over the internet.

• Web APIs use HTTP protocols to enable communication between systems.

• Examples of web APIs include RESTful APIs, SOAP APIs, and G
Answered by AI
Add your answer

Q1. Project discussion
Add your answer
Q2. Details of project
Add your answer

Q1. Salary discussion
Add your answer

Data structures and algorithm

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