i
Mphasis
Filter interviews by
I applied via Naukri.com and was interviewed in Feb 2024. There was 1 interview round.
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
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.
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
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.
I applied via LinkedIn and was interviewed before Jan 2024. There was 1 interview round.
Abstraction is hiding the implementation details while interface is a contract that defines the methods that a class must implement.
Abstraction focuses on hiding the internal implementation details of a class, allowing the user to only see the necessary information.
Interfaces define a set of methods that a class must implement, without specifying how those methods are implemented.
Abstraction can be achieved through abs...
Ref vs Out parameters in C#
Ref parameters must be initialized before passing to a method, while Out parameters do not need to be initialized.
Ref parameters can be read and modified within the method, while Out parameters are typically used for output values only.
Example: void ModifyValue(ref int num) { num = 10; } vs void GetOutput(out int result) { result = 20; }
Middleware in .NET Core is a component that can handle requests and responses in the application pipeline.
Middleware is a piece of software that can intercept and process HTTP requests and responses in the application pipeline.
Middleware can be used for logging, authentication, authorization, error handling, and more.
Middleware is added to the application pipeline using the app.UseMiddleware() method in the Configure m...
Authentication in web API is crucial for securing access to resources and ensuring data privacy.
Use token-based authentication like JWT for secure communication between client and server
Implement OAuth2 for authorization and access control
Use HTTPS to encrypt data transmission and prevent man-in-the-middle attacks
I applied via Recruitment Consulltant and was interviewed before Jun 2023. There were 2 interview rounds.
String is immutable in order to ensure data integrity and security.
Immutable strings prevent accidental changes to data, ensuring consistency in programs.
Immutable strings allow for more efficient memory management and optimization.
Example: In Java, once a string object is created, its value cannot be changed.
Extrusion is a process used to create objects of a fixed cross-sectional profile.
Extrusion is a manufacturing process where a material is pushed through a die to create a specific shape.
Common materials used in extrusion include metals, plastics, and food products.
Examples of extruded products include pipes, rods, and window frames.
What people are saying about Mphasis
Sort array of strings based on custom logic
Define the custom logic for sorting
Implement a sorting algorithm such as bubble sort or quicksort
Apply the custom logic during the sorting process
Check if a string is a palindrome or not.
Reverse the string and compare it with the original string.
Use two pointers, one at the beginning and one at the end, and compare the characters.
Ignore non-alphanumeric characters and convert to lowercase before checking.
Mphasis interview questions for designations
My dream is to build innovative software solutions that positively impact people's lives.
Developing cutting-edge technology
Creating user-friendly interfaces
Solving complex problems
Collaborating with talented individuals
Making a difference in society
Continuous learning and growth
I applied via Recruitment Consulltant and was interviewed before Apr 2021. There were 3 interview rounds.
Standard Aptitude questions
Based on strings and array
I applied via Naukri.com and was interviewed before Oct 2020. There were 5 interview rounds.
C++ is an extension of C with object-oriented programming features.
C++ supports classes and objects while C does not.
C++ has better support for polymorphism and inheritance.
C++ has a standard template library (STL) which C does not have.
C++ allows function overloading while C does not.
C++ has exception handling while C does not.
For loop is used for iterating over a sequence while while loop is used for iterating until a condition is met.
For loop is used when the number of iterations is known beforehand
While loop is used when the number of iterations is not known beforehand
For loop is faster than while loop for iterating over a sequence
While loop is useful for iterating until a specific condition is met
For loop can be used with range() functio...
To reverse a string without using any looping and inbuilt functions, we can use recursion.
Create a function that takes a string as input.
If the length of the string is 0 or 1, return the string.
Otherwise, call the function recursively with the substring starting from the second character and concatenate the first character at the end.
Return the reversed string.
Example: reverseString('hello') returns 'olleh'.
A priority queue can be implemented using a single queue or multiple queues.
One approach is to use a single queue and assign priorities to elements using a separate data structure.
Another approach is to use multiple queues, each representing a different priority level.
For example, if there are three priority levels, three queues can be used to implement the priority queue.
An array of objects can be used to implement a heterogeneous array.
Each element in the array can be an object that represents a different data type.
The objects can have different properties and methods based on their respective data types.
For example, an element can be an object representing a string with a 'value' property and a 'length' method.
Developed a web-based inventory management system for a retail company.
Used HTML, CSS, and JavaScript for the front-end development.
Implemented a RESTful API using Node.js and Express for the back-end.
Utilized a MySQL database to store and manage inventory data.
Implemented features like product search, order management, and reporting.
Ensured data security and user authentication using encryption and JWT.
Collaborated wi...
The missing rupee is not actually missing. The calculation is misleading and does not account for the total amount paid.
The initial amount paid by each person was Rs.10, totaling Rs.30.
The owner gave them a discount of Rs.5, so they paid Rs.25 in total.
The broker took Rs.2, leaving them with Rs.23.
When the broker returned Rs.1 to each person, they each received Rs.1 back, totaling Rs.3.
So, the total amount paid by the ...
Inheritance in Java allows a class to inherit properties and methods from another class.
Inheritance is achieved using the 'extends' keyword.
The class that is being inherited from is called the superclass or parent class.
The class that inherits from the superclass is called the subclass or child class.
Subclasses can access the public and protected members of the superclass.
Inheritance promotes code reusability and allow...
A program to check if a given number is a palindrome or not.
Convert the number to a string.
Reverse the string and compare it with the original string.
If they are equal, the number is a palindrome.
If not, the number is not a palindrome.
Normalisation is the process of organizing data in a database to reduce redundancy and improve data integrity.
It involves breaking down a table into smaller tables and defining relationships between them.
Normalization helps to eliminate data inconsistencies and anomalies.
There are different levels of normalization, with each level having specific rules to follow.
For example, first normal form (1NF) requires that each t...
Yes, I am ready to relocate anywhere in India or outside upon company needs.
I am open to exploring new locations and cultures.
I understand that relocation may be necessary for career growth and opportunities.
I am adaptable and willing to adjust to new environments.
I have experience working in diverse teams and can easily integrate into new settings.
I would be ready to accept a project in Java even if I was trained in DotNet earlier.
I have a strong foundation in programming principles and concepts, which can be applied to any language.
I am confident in my ability to quickly learn and adapt to new technologies.
I have experience working with multiple programming languages and frameworks.
I can leverage my knowledge of DotNet to understand similar concepts in Java.
I a...
I want to join Sapient because of its reputation for innovative projects and collaborative work environment.
Sapient is known for working on cutting-edge projects that push the boundaries of technology
I value the collaborative work environment at Sapient, where team members support each other to achieve success
I am impressed by Sapient's commitment to professional development and growth opportunities for employees
My expectations from Sapient
I expect Sapient to provide a challenging and innovative work environment
I expect Sapient to offer opportunities for professional growth and learning
I expect Sapient to have a collaborative and supportive team culture
I expect Sapient to provide competitive compensation and benefits
I expect Sapient to have a strong focus on quality and delivering excellent software solutions
based on 3 interviews
Interview experience
based on 45 reviews
Rating in categories
Software Engineer
6.4k
salaries
| ₹2 L/yr - ₹9.5 L/yr |
Senior Software Engineer
5.7k
salaries
| ₹6 L/yr - ₹23.6 L/yr |
Associate Software Engineer
4.7k
salaries
| ₹2 L/yr - ₹6 L/yr |
Module Lead
2.4k
salaries
| ₹9.5 L/yr - ₹35 L/yr |
Transaction Processing Officer
2.3k
salaries
| ₹1.4 L/yr - ₹4.5 L/yr |
Cognizant
Wipro
Accenture
TCS