Mphasis Team Lead Interview Questions and Answers

Q1. Performance optimisation
Add your answer

Q1. Lods,parameters
Add your answer

Q1. Sql queries on analytical queries
Add your answer
Q2. Different constraints and join methods
Ans. 
Different constraints and join methods in database queries
• Constraints in database queries ensure data integrity and enforce rules on data

• Join methods in database queries are used to combine rows from two or more tables based on a related column between them

• Examples of constraints include primary key, foreign key, unique key, and check constraints

• Examples of join methods include inner join, outer join (left, right, full
Answered by AI
Add your answer

It was mostly on sub queries.

Q1. Write a join in sql
Ans. 
A SQL join is used to combine rows from two or more tables based on a related column between them.
• Use the JOIN keyword to specify the tables to be joined

• Use the ON keyword to specify the column to join on

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Answered by AI
Add your answer
Q2. Java related many questions
Add your answer

Q1. Explain your project in details
Add your answer
Q2. Write 2 any joins in sql
Ans. 
Two common SQL joins are INNER JOIN and LEFT JOIN.
• INNER JOIN: Returns rows when there is at least one match in both tables.

• LEFT JOIN: Returns all rows from the left table and the matched rows from the right table.
Answered by AI
Add your answer