Mphasis Interview Questions, Process, and Tips for Experienced

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

Q1. What is Java and usage of java
Add your answer

Q1. Interview questions based on your technology
Add your answer
Q2. If database,what is procedure & function
Ans. 
Procedures and functions are stored routines in a database that can be called to perform specific tasks.
• Procedures are a set of SQL statements that perform a specific task. They can have input and output parameters.

• Functions are similar to procedures but return a value. They can be used in SQL queries like any other function.

• Both procedures and functions can improve code reusability and maintainability in a database sy
Answered by AI
Add your answer
Q3. What is trigger
Ans. 
A trigger is a special kind of stored procedure that is automatically executed when certain events occur in a database.
• Triggers are used to maintain data integrity by enforcing business rules or cascading changes.

• They can be set to execute before or after INSERT, UPDATE, or DELETE operations.

• Examples include auditing changes to a table, updating related records in other tables, or enforcing constraints.
Answered by AI
Add your answer
Q4. What'sis database
Ans. 
A database is a structured collection of data that is stored and accessed electronically.
• Database organizes and stores data in tables

• It allows for efficient retrieval, insertion, and updating of data

• Examples include MySQL, Oracle, MongoDB
Answered by AI
Add your answer
Q5. What is primary key?
Ans. 
Primary key is a unique identifier for each record in a database table.
• Primary key ensures each record in a table is uniquely identified.

• It must have a unique value for each record.

• Primary key can be a single column or a combination of columns.

• Examples: ID column in a user table, combination of first name and last name in an employee table.
Answered by AI
Add your answer

Coding and some basic questions

Basic questions on Java and DB.