Mphasis Senior Associate Interview Questions and Answers

Q1. Write a program to sort an array
Add your answer
Q2. How to improve the performance of asp application
Add your answer

Q1. SQL practical questions
Add your answer
Q2. Different methods of scan in explain plan
Ans. 
Different methods of scan in explain plan include table scan, index scan, bitmap scan, and sequential scan.
• Table scan: Reads all rows in a table to find the required data.

• Index scan: Uses an index to locate the required data.

• Bitmap scan: Uses a bitmap index to efficiently retrieve data.

• Sequential scan: Reads all rows in a table in order.
Answered by AI
Add your answer
Q3. Different methods of optimization
Ans. 
Different methods of optimization include linear programming, genetic algorithms, simulated annealing, and gradient descent.
• Linear programming involves maximizing or minimizing a linear objective function subject to linear equality and inequality constraints.

• Genetic algorithms are inspired by the process of natural selection and use techniques such as mutation, crossover, and selection to find optimal solutions.

• Simulat...read more
Answered by AI
Add your answer
Q4. Bulk collect and bulk binding
Add your answer
Q5. How many triggers we can have at a time
Ans. 
The number of triggers that can be active at a time depends on the system and its limitations.
• The number of triggers can vary based on the software or hardware being used.

• Some systems may have a limit on the number of triggers that can be active simultaneously.

• It is important to check the documentation or specifications of the system to determine the maximum number of triggers allowed.

• For example, a database management...read more
Answered by AI
Add your answer

Q1. Aws cloud core services
Add your answer
Q2. Ansible terraform docker jenkins
Add your answer

Q1. How do you handle conflicts at work?
Ans. 
I address conflicts by actively listening, understanding all perspectives, and finding a mutually beneficial solution.
• Actively listen to all parties involved

• Seek to understand each person's perspective

• Collaborate to find a mutually beneficial solution

• Maintain professionalism and respect throughout the process
Answered by AI
Add your answer
Q2. What were your roles and responsibilities at your previous company?
Ans. 
I was responsible for managing client relationships, leading project teams, and overseeing project deliverables.
• Managed client relationships to ensure satisfaction and retention

• Led project teams to meet deadlines and deliver high-quality work

• Oversaw project deliverables to ensure they met client expectations

• Collaborated with cross-functional teams to achieve project goals
Answered by AI
Add your answer

Q1. Which company will hire
Add your answer

Q1. What will my salary.
Add your answer
Q2. How much experience need to company
Add your answer

Is this job for bpo back office.