Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Mphasis Team. If you also belong to the team, you can get access from here

Mphasis Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Mphasis Plsql Developer Interview Questions and Answers

Updated 3 Mar 2025

11 Interview questions

A Plsql Developer was asked 3mo ago
Q. What are analytical functions in SQL?
Ans. 

Analytical functions in SQL are used to perform calculations across a set of rows related to the current row.

  • Analytical functions operate on a group of rows and return a single result for each row.

  • They can be used to calculate running totals, moving averages, rank, percentiles, etc.

  • Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), SUM() OVER(), AVG() OVER().

A Plsql Developer was asked 3mo ago
Q. Can you describe two complex JIRA issues you have worked on?
Ans. 

Resolved a critical bug causing data loss and implemented a new feature for better user experience.

  • Identified root cause of data loss bug by analyzing database queries and logs

  • Collaborated with cross-functional teams to prioritize and implement a fix

  • Designed and implemented a new feature based on user feedback to enhance usability

Plsql Developer Interview Questions Asked at Other Companies

asked in TCS
Q1. What is temp table and temp variable in plsql?
asked in TCS
Q2. What is procedure in plsql and it's syntax and difference between ... read more
asked in TCS
Q3. Write a PL/SQL program to print the sequence 103, 99, 96...3.
asked in TCS
Q4. What is a mutating table or mutating trigger?
asked in Cognizant
Q5. Write a SQL query to delete duplicate records from a table.
A Plsql Developer was asked 3mo ago
Q. What is the difference between procedures and functions in programming?
Ans. 

Procedures are used to perform an action, while functions return a value.

  • Procedures do not return a value, while functions do.

  • Functions can be used in SQL queries, while procedures cannot.

  • Functions can be called from within SQL statements, while procedures cannot.

  • Procedures can have OUT parameters to return multiple values, while functions can only return a single value.

A Plsql Developer was asked 3mo ago
Q. What steps did you take to perform root cause analysis in your project?
Ans. 

I conducted thorough analysis by reviewing code, logs, and discussing with team members.

  • Reviewed code to identify potential issues

  • Analyzed logs for error messages and patterns

  • Discussed with team members to gather insights and perspectives

  • Used debugging tools to trace the root cause

A Plsql Developer was asked 3mo ago
Q. What is a trigger in database management, and what are its different types?
Ans. 

A trigger in database management is a special type of stored procedure that is automatically executed when certain events occur in a database.

  • Triggers can be used to enforce business rules, maintain referential integrity, and automate repetitive tasks.

  • There are two main types of triggers: row-level triggers and statement-level triggers.

  • Row-level triggers are fired for each row affected by a triggering statement, w...

A Plsql Developer was asked 3mo ago
Q. What are the different types of indexes?
Ans. 

Different types of indexes include B-tree, Bitmap, Function-based, and Reverse key indexes.

  • B-tree indexes are the most common type and are suitable for most indexing needs.

  • Bitmap indexes are used for columns with low cardinality, such as gender or status columns.

  • Function-based indexes are created based on expressions or functions applied to columns.

  • Reverse key indexes store keys in reverse order to reduce contenti...

A Plsql Developer was asked 3mo ago
Q. What are the different types of cursors in database management systems?
Ans. 

Types of cursors in database management systems include implicit, explicit, and parameterized cursors.

  • Implicit cursors are automatically created by the database when a SQL statement is executed.

  • Explicit cursors are defined by the programmer and give more control over the result set.

  • Parameterized cursors allow for dynamic SQL statements with parameters.

  • Examples: SELECT statement using implicit cursor, DECLARE, OPEN...

Are these interview questions helpful?
A Plsql Developer was asked 3mo ago
Q. What is a package, and how do you utilize it in your project?
Ans. 

A package is a collection of related procedures, functions, variables, and other PL/SQL constructs.

  • Packages help organize and encapsulate code for easier maintenance and reuse.

  • They can contain both public and private elements.

  • Packages can be used to group related functionality together, improving code modularity.

  • Example: CREATE PACKAGE my_package AS ... END my_package;

A Plsql Developer was asked 3mo ago
Q. What is the query to print the third highest salary from the given table?
Ans. 

Use a subquery to find the third highest salary in a table.

  • Use the RANK() function to assign a rank to each salary in descending order.

  • Filter the results to only include rows with a rank of 3.

  • Consider handling ties in salaries appropriately.

A Plsql Developer was asked 3mo ago
Q. What are joins in SQL, and can you provide examples of their usage?
Ans. 

Joins in SQL are used to combine rows from two or more tables based on a related column between them.

  • Joins are used to retrieve data from multiple tables based on a related column.

  • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

  • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

Mphasis Plsql Developer Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
-
Round 1 - Technical 

(15 Questions)

  • Q1. Self introduction and questions related to my project
  • Q2. What are joins in SQL, and can you provide examples of their usage?
  • Ans. 

    Joins in SQL are used to combine rows from two or more tables based on a related column between them.

    • Joins are used to retrieve data from multiple tables based on a related column.

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

  • Answered by AI
  • Q3. What are the built-in functions available in SQL?
  • Ans. 

    Some built-in functions in SQL include AVG, COUNT, MAX, MIN, SUM, and CONCAT.

    • AVG: Calculates the average value of a numeric column

    • COUNT: Counts the number of rows in a result set

    • MAX: Returns the maximum value in a column

    • MIN: Returns the minimum value in a column

    • SUM: Calculates the sum of values in a column

    • CONCAT: Concatenates two or more strings together

  • Answered by AI
  • Q4. What are the different types of cursors in database management systems?
  • Ans. 

    Types of cursors in database management systems include implicit, explicit, and parameterized cursors.

    • Implicit cursors are automatically created by the database when a SQL statement is executed.

    • Explicit cursors are defined by the programmer and give more control over the result set.

    • Parameterized cursors allow for dynamic SQL statements with parameters.

    • Examples: SELECT statement using implicit cursor, DECLARE, OPEN, FET...

  • Answered by AI
  • Q5. What is the difference between procedures and functions in programming?
  • Ans. 

    Procedures are used to perform an action, while functions return a value.

    • Procedures do not return a value, while functions do.

    • Functions can be used in SQL queries, while procedures cannot.

    • Functions can be called from within SQL statements, while procedures cannot.

    • Procedures can have OUT parameters to return multiple values, while functions can only return a single value.

  • Answered by AI
  • Q6. What is the query to print the third highest salary from the given table?
  • Ans. 

    Use a subquery to find the third highest salary in a table.

    • Use the RANK() function to assign a rank to each salary in descending order.

    • Filter the results to only include rows with a rank of 3.

    • Consider handling ties in salaries appropriately.

  • Answered by AI
  • Q7. What is a package, and how do you utilize it in your project?
  • Ans. 

    A package is a collection of related procedures, functions, variables, and other PL/SQL constructs.

    • Packages help organize and encapsulate code for easier maintenance and reuse.

    • They can contain both public and private elements.

    • Packages can be used to group related functionality together, improving code modularity.

    • Example: CREATE PACKAGE my_package AS ... END my_package;

  • Answered by AI
  • Q8. Can you describe two complex JIRA issues you have worked on?
  • Ans. 

    Resolved a critical bug causing data loss and implemented a new feature for better user experience.

    • Identified root cause of data loss bug by analyzing database queries and logs

    • Collaborated with cross-functional teams to prioritize and implement a fix

    • Designed and implemented a new feature based on user feedback to enhance usability

  • Answered by AI
  • Q9. What are the different types of indexes?
  • Ans. 

    Different types of indexes include B-tree, Bitmap, Function-based, and Reverse key indexes.

    • B-tree indexes are the most common type and are suitable for most indexing needs.

    • Bitmap indexes are used for columns with low cardinality, such as gender or status columns.

    • Function-based indexes are created based on expressions or functions applied to columns.

    • Reverse key indexes store keys in reverse order to reduce contention in...

  • Answered by AI
  • Q10. What are analytical functions in sql?
  • Ans. 

    Analytical functions in SQL are used to perform calculations across a set of rows related to the current row.

    • Analytical functions operate on a group of rows and return a single result for each row.

    • They can be used to calculate running totals, moving averages, rank, percentiles, etc.

    • Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), SUM() OVER(), AVG() OVER().

  • Answered by AI
  • Q11. What are aggregate functions in SQL?
  • Ans. 

    Aggregate functions in SQL are functions that operate on a set of values and return a single value as output.

    • Aggregate functions include functions like SUM, AVG, COUNT, MIN, and MAX.

    • They are used with the GROUP BY clause to perform calculations on groups of rows.

    • Examples: SELECT SUM(salary) FROM employees; SELECT AVG(age) FROM students GROUP BY class;

  • Answered by AI
  • Q12. How did you handle performance tuning in your project?
  • Ans. 

    I identified and optimized slow-performing SQL queries by analyzing execution plans and indexing strategies.

    • Identified slow-performing SQL queries using tools like Oracle SQL Developer or TOAD.

    • Analyzed execution plans to understand query performance bottlenecks.

    • Optimized queries by rewriting SQL code, adding indexes, or restructuring data.

    • Used tools like Explain Plan or SQL Tuning Advisor to improve query performance.

    • R...

  • Answered by AI
  • Q13. What is data modeling?
  • Ans. 

    Data modeling is the process of creating a visual representation of data structures and relationships within a database.

    • Data modeling helps in organizing and understanding complex data systems.

    • It involves identifying entities, attributes, and relationships between them.

    • Examples include ER diagrams, UML diagrams, and relational data models.

  • Answered by AI
  • Q14. What steps did you take to perform root cause analysis in your project?
  • Ans. 

    I conducted thorough analysis by reviewing code, logs, and discussing with team members.

    • Reviewed code to identify potential issues

    • Analyzed logs for error messages and patterns

    • Discussed with team members to gather insights and perspectives

    • Used debugging tools to trace the root cause

  • Answered by AI
  • Q15. What is a trigger in database management, and what are its different types?
  • Ans. 

    A trigger in database management is a special type of stored procedure that is automatically executed when certain events occur in a database.

    • Triggers can be used to enforce business rules, maintain referential integrity, and automate repetitive tasks.

    • There are two main types of triggers: row-level triggers and statement-level triggers.

    • Row-level triggers are fired for each row affected by a triggering statement, while ...

  • Answered by AI

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
1w (edited)
a team lead
Why are women still asked such personal questions in interview?
I recently went for an interview… and honestly, m still trying to process what just happened. Instead of being asked about my skills, experience, or how I could add value to the company… the questions took a totally unexpected turn. The interviewer started asking things like When are you getting married? Are you engaged? And m sure, if I had said I was married, the next question would’ve been How long have you been married? What does my personal life have to do with the job m applying for? This is where I felt the gender discrimination hit hard. These types of questions are so casually thrown at women during interviews but are they ever asked to men? No one asks male candidates if they’re planning a wedding or how old their kids are. So why is it okay to ask women? Can we please stop normalising this kind of behaviour in interviews? Our careers shouldn’t be judged by our relationship status. Period.
Got a question about Mphasis?
Ask anonymously on communities.

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(4 Questions)

  • Q1. Difference between delete, drop and truncate
  • Ans. 

    Delete removes rows from a table, drop removes the entire table, and truncate removes all rows from a table.

    • Delete is a DML operation and can be rolled back, but it is slower than truncate.

    • Drop is a DDL operation and cannot be rolled back. It removes the table and all associated objects.

    • Truncate is a DDL operation and cannot be rolled back. It removes all rows from the table but keeps the table structure.

    • Delete and tru...

  • Answered by AI
  • Q2. Difference between table and view
  • Ans. 

    Table stores data in a structured format while view is a virtual table created from a query.

    • Table is a physical object while view is a logical object.

    • Table can be modified while view cannot be modified directly.

    • Table can have indexes while view cannot have indexes.

    • Table can have constraints while view cannot have constraints.

    • View can be used to simplify complex queries by joining multiple tables.

    • View can be used to res...

  • Answered by AI
  • Q3. What type of cursors did you use
  • Ans. 

    I have used both implicit and explicit cursors in PL/SQL development.

    • Implicit cursors are used for single-row queries while explicit cursors are used for multi-row queries.

    • I have used explicit cursors with parameters to make the query more dynamic.

    • I have also used cursor variables to pass cursors as parameters to procedures and functions.

    • Examples of cursor types I have used include FOR LOOP, FETCH, and UPDATE cursors.

  • Answered by AI
  • Q4. What is primary key and unique key
  • Ans. 

    Primary key uniquely identifies a record in a table, while unique key ensures uniqueness of a column or set of columns.

    • Primary key is a column or set of columns that uniquely identifies each record in a table

    • Unique key ensures that a column or set of columns have unique values

    • Primary key cannot have null values, while unique key can have null values

    • A table can have only one primary key, but multiple unique keys

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident in the interview.
Frame your answer correctly.if you don't know any complex question ask the interviewer at the end

Skills evaluated in this interview

Plsql Developer Interview Questions Asked at Other Companies

asked in TCS
Q1. What is temp table and temp variable in plsql?
asked in TCS
Q2. What is procedure in plsql and it's syntax and difference between ... read more
asked in TCS
Q3. Write a PL/SQL program to print the sequence 103, 99, 96...3.
asked in TCS
Q4. What is a mutating table or mutating trigger?
asked in Cognizant
Q5. Write a SQL query to delete duplicate records from a table.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. CREATE A FUNCTION BASED ONLOGIC SHARED
  • Ans. 

    Create a function based on shared logic

    • Identify common logic that can be reused in multiple functions

    • Create a separate function to encapsulate the shared logic

    • Call the shared function from other functions where the logic is needed

  • Answered by AI
  • Q2. FOR AN ENTITY GIVE DTAILS OF PREVOUS AND NEXT DATE FOR PARTICULAR DEPATMENT
  • Ans. 

    Retrieve previous and next dates for a specific department's entity in a database using PL/SQL.

    • Use a SELECT statement with JOINs to fetch data from relevant tables.

    • Utilize the LEAD() and LAG() analytic functions to get next and previous dates.

    • Example: SELECT department_id, date_column, LAG(date_column) OVER (PARTITION BY department_id ORDER BY date_column) AS previous_date, LEAD(date_column) OVER (PARTITION BY departme...

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. EXPLAIN ABOUT UR PRJECT
  • Ans. 

    Developed a PL/SQL project for managing inventory and sales data in a retail store.

    • Designed database tables to store product information, sales transactions, and customer details.

    • Implemented PL/SQL procedures and functions for adding, updating, and querying data.

    • Created triggers to enforce business rules and maintain data integrity.

    • Developed reports using PL/SQL queries to analyze sales performance and inventory levels...

  • Answered by AI
  • Q2. How do you work on performance optimization
  • Ans. 

    I work on performance optimization by analyzing query execution plans, indexing, and code refactoring.

    • Analyzing query execution plans to identify bottlenecks

    • Creating appropriate indexes to improve query performance

    • Refactoring code to optimize resource usage

    • Using tools like Explain Plan and SQL Tuning Advisor

  • Answered by AI

I applied via Naukri.com and was interviewed before Sep 2019. There were 6 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. IQ Test
  • Q2. Machine Test
  • Q3. Face To Face

Interview Preparation Tips

Interview preparation tips for other job seekers - basically there are 3 rounds:-
1. IQ Test
2. Machine Test
3. Face to Face

IQ Test is not so tough but prepare well Machine Test
Machine Test Question are like :-
Q.1 - We declare a variable in C++ like "is_this_a_variable" and in Java like "IsThisAVariable". There is underscore in between every word and first alphabet of every word is in lowercase in C++ and in Java first alphabet is in capital without underscore. Create a program in which if user input a string in a C++ variable format it will convert the input in java variable format.

Q2. Count the frequency of a string.
user input string - pqhphi
output-
p - 2
q - 1
h - 2
i - 1

Be strong in algorithms and data structure.

Interview Questionnaire 

1 Question

  • Q1. All about SQL joins,data warehouse.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared and answer only if you know the concept clearly.

Interview Preparation Tips

Round: Test
Experience: Apti was quite easy . In Basic CS concepts software engineering is prominent.
Tips: Brush up Software Engineering before written test
Duration: 90 minutes
Total Questions: 50

College Name: NIT BHOPAL
Are these interview questions helpful?

Interview Questionnaire 

13 Questions

  • Q1. Indroduce yourself ?
  • Ans. 

    I am a software developer with experience in various programming languages and frameworks.

    • Proficient in Java, C++, and Python

    • Familiar with web development using HTML, CSS, and JavaScript

    • Experience with database management systems such as MySQL and MongoDB

    • Strong problem-solving and analytical skills

    • Worked on projects involving machine learning and artificial intelligence

  • Answered by AI
  • Q2. Difference between method overloading and methode overriding ?
  • Ans. 

    Method overloading is having multiple methods with the same name but different parameters. Method overriding is having a subclass method with the same name and parameters as a superclass method.

    • Method overloading is used to provide different ways of calling the same method with different parameters.

    • Method overriding is used to provide a specific implementation of a method in a subclass that is already defined in the su...

  • Answered by AI
  • Q3. Difference between switch case and if else statement?
  • Ans. 

    Switch case is used for multiple conditions while if else is used for binary conditions.

    • Switch case is faster than if else for multiple conditions.

    • If else can handle complex conditions while switch case cannot.

    • Switch case can only compare values of the same data type.

    • If else can handle null values while switch case cannot.

    • Example: switch (day) { case 1: console.log('Monday'); break; case 2: console.log('Tuesday'); brea...

  • Answered by AI
  • Q4. What is interface and abstract class?
  • Ans. 

    Interface and abstract class are both used for abstraction in object-oriented programming.

    • An interface is a collection of abstract methods that define a contract for a class to implement.

    • An abstract class is a class that cannot be instantiated and may contain abstract methods.

    • Interfaces are used to achieve multiple inheritance in Java.

    • Abstract classes can have non-abstract methods and instance variables.

    • An example of a...

  • Answered by AI
  • Q5. Whats is polymorphisom?
  • Ans. 

    Polymorphism is the ability of an object to take on many forms.

    • It allows objects of different classes to be treated as if they were objects of the same class.

    • It is achieved through method overriding and method overloading.

    • Example: A shape class can have multiple subclasses like circle, square, etc. and all can be treated as shapes.

    • Example: A method can have different implementations in different classes but with the sa...

  • Answered by AI
  • Q6. What is inherritance ?
  • Ans. 

    Inheritance is a mechanism in object-oriented programming where a new class is created by inheriting properties of an existing class.

    • Inheritance allows code reusability and saves time and effort in writing new code.

    • The existing class is called the parent or base class, and the new class is called the child or derived class.

    • The child class inherits all the properties and methods of the parent class and can also add its ...

  • Answered by AI
  • Q7. Default case in switch case
  • Ans. 

    Default case in switch case statement

    • Default case is executed when no other case matches the switch expression

    • It is optional and can be placed anywhere in the switch statement

    • It is often used to handle unexpected input or errors

    • It should always be the last case in the switch statement

  • Answered by AI
  • Q8. Introduce yourself apart from resume?
  • Ans. 

    I am a passionate software developer with a strong background in web development and a love for problem-solving.

    • Experienced in HTML, CSS, JavaScript, and various web development frameworks

    • Proficient in backend development using languages like Java, Python, and Node.js

    • Familiar with database management systems such as MySQL and MongoDB

    • Strong problem-solving skills and ability to work well in a team environment

  • Answered by AI
  • Q9. What is your weaknesses ?
  • Ans. 

    I tend to get overly focused on details, which can sometimes slow down my progress.

    • I have a tendency to spend too much time on perfecting small details

    • I sometimes struggle with prioritizing tasks due to my focus on details

    • I am working on improving my time management skills to balance detail-oriented work with efficiency

  • Answered by AI
  • Q10. Do you have any offer from any other company ?
  • Ans. 

    Yes, I have received offers from two other companies.

    • Received offers from Company A and Company B

    • Currently evaluating all offers to make an informed decision

    • Considering factors like company culture, growth opportunities, and compensation

  • Answered by AI
  • Q11. Which company would you like to join apart from sapient ?
  • Ans. 

    I would like to join Google because of their innovative projects and work culture.

    • Google is known for its cutting-edge technology and innovative projects.

    • They have a strong focus on employee well-being and work-life balance.

    • Google offers opportunities for career growth and development.

    • The company has a diverse and inclusive work culture.

    • Google is a leader in the tech industry with a global presence.

  • Answered by AI
  • Q12. Have you ever worked in a team?
  • Ans. 

    Yes, I have worked in multiple teams in various projects.

    • Worked in a team of developers to create a new software application

    • Collaborated with designers, testers, and project managers to meet project deadlines

    • Participated in daily stand-up meetings to discuss progress and roadblocks

  • Answered by AI
  • Q13. 8 metals bolls are similar ?
  • Ans. 

    Yes, they are similar.

    • All 8 metal balls are of the same material.

    • They have the same size and weight.

    • They have the same physical properties.

    • They are interchangeable in any given situation.

  • Answered by AI

Interview Preparation Tips

College Name: NIT Meghalaya

Skills evaluated in this interview

Interview Questionnaire 

11 Questions

  • Q1. What is the difference between C and C++?
  • Q2. What is the difference between for and while loop?
  • Q3. Write a program to add two numbers without using + operator
  • Q4. How to you reverse a string without using any looping and inbuilt functions?
  • Ans. 

    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'.

  • Answered by AI
  • Q5. How many queues will you use to implement a priority queue?
  • Q6. Which datastructure would you use to implement an heteregenous array?
  • Q7. Tell me about yourself?
  • Q8. Describe your project?
  • Ans. 

    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...

  • Answered by AI
  • Q9. You are given a match-box and two candles of equal size, which can burn 1 hour each. You have to measure 90 minutes with these candles. (There is no scale or clock). How do you do?
  • Q10. You have 8 balls which are identical(completely). You are given a weighing scale. How many times would you measure to get the odd ball out?
  • Q11. Three friends rent a room for Rs.30 by paying Rs.10 each. The owner decides to give them a discount Rs.5 and gives it to the broker. The broker who a cunning man takes Rs.2. and returns one rupee to each ...
  • Ans. 

    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 ...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Let me share my interview process with Sapient. As I did not find any helpful papers before attending interview.The initial test was amcat test, which consisted of aptitude, english comprehension(which was annoying because they ask a lot of unknown word meanings), C and C++ basic concepts. I cleared that test.

Round: Technical Interview
Experience: There are 2 interviews round
1) Technical
2) HR

General Tips: Bond: 1.5 yearEligibility Criteria : Greater than 6.5 CGPA
Skills: C++, Java, Algorithm
College Name: NA
Motivation: Sapient, Trust me it’s an awesome company .Be strong in technical area.

Skills evaluated in this interview

Interview Questionnaire 

13 Questions

  • Q1. Inheritence in java?
  • Ans. 

    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...

  • Answered by AI
  • Q2. Overloading and Overridding?
  • Q3. WAP to check if no is palindrom or not?
  • Ans. 

    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.

  • Answered by AI
  • Q4. Primary key and Composite key?
  • Q5. Normalisation?
  • Ans. 

    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...

  • Answered by AI
  • Q6. Without lifting the pen meet 9 point arranged in squre of 3×3, using 4 lines?
  • Q7. If I am ready to relocate anywhere in India or Outside upon company needs
  • Ans. 

    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.

  • Answered by AI
  • Q8. If I am ready to accept a project in Java, if Sapient had trained you in DotNet earlier
  • Ans. 

    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...

  • Answered by AI
  • Q9. Why I want to join Sapient
  • Ans. 

    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

  • Answered by AI
  • Q10. My Expectations from Sapient
  • Ans. 

    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

  • Answered by AI
  • Q11. What is Counter Strike. ( I mentioned winning a couple of gaming events in my Resume)
  • Q12. What is Trading/Stocks/Exchange. (I had shown my interest in these things by mentioning the development of DalalStreet website by me)
  • Q13. What are you proud of apart from your website DalalStreet and a few more

Interview Preparation Tips

Round: Test
Experience: Vendor based online test consisting of 4 sections – Maths, Logical Reasoning, English and Technical(C/C++/DS/Debugging based Questions). This includes Sectional CutOff as well.

Round: Technical Interview
Experience: Another One on One Interview. Technical Questions on Languages/DataBases and Projects/Internships mentioned by you in your Resume. Lots of Puzzles.
In my case the Interviewer asked me questions on Database(3-4 queries),PHP,HTML,CSS,Internship,C/C++ Basics. Also I had 4 puzzles.

Round: HR Interview
Experience: Key : Just be yourself and be Confident in whatever you say. Show your eagerness to learn things (even if you don’t want to ). If you don’t know anything, Confidently speak up you don’t know. They hardly care, they only see if you are willing to learn.

General Tips: I would add here that SGM is majorly into developing Trading application. SGM – GlobalMarketInstitute would provide you with 6 months of training in technology(Java/DotNet) and Finance(Share/Exchange/Equities etc), which would be a great experience. Hence a knowledge and interest in Share Trading stuff is highly appreciated if you plan to grow your career in Sapient Global Markets.(Bond Agreement of 1.5 years which includes 6 months of Training Period)
Skills: PHP, Databases, C++, Java, .NET
College Name: MNIT Jaipur

Skills evaluated in this interview

Mphasis Interview FAQs

How many rounds are there in Mphasis Plsql Developer interview?
Mphasis interview process usually has 1 rounds. The most common rounds in the Mphasis interview process are Technical.
How to prepare for Mphasis Plsql Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Mphasis. The most common topics and skills that interviewers at Mphasis expect are PLSQL, SQL Development, Oracle 10G, Oracle Development and Oracle PL.
What are the top questions asked in Mphasis Plsql Developer interview?

Some of the top questions asked at the Mphasis Plsql Developer interview -

  1. What are the different types of cursors in database management syste...read more
  2. What is a package, and how do you utilize it in your proje...read more
  3. What is the query to print the third highest salary from the given tab...read more

Tell us how to improve this page.

Overall Interview Experience Rating

3/5

based on 1 interview experience

Difficulty level

Moderate 100%
View more
Mphasis Plsql Developer Salary
based on 191 salaries
₹2.8 L/yr - ₹7.9 L/yr
16% less than the average Plsql Developer Salary in India
View more details

Mphasis Plsql Developer Reviews and Ratings

based on 9 reviews

4.1/5

Rating in categories

4.5

Skill development

3.8

Work-life balance

4.0

Salary

4.2

Job security

4.2

Company culture

3.7

Promotions

4.1

Work satisfaction

Explore 9 Reviews and Ratings
Software Engineer
6.8k salaries
unlock blur

₹4 L/yr - ₹8.4 L/yr

Senior Software Engineer
6k salaries
unlock blur

₹6.6 L/yr - ₹20 L/yr

Associate Software Engineer
4.9k salaries
unlock blur

₹2 L/yr - ₹5.6 L/yr

Module Lead
2.5k salaries
unlock blur

₹15.8 L/yr - ₹27 L/yr

Transaction Processing Officer
2.3k salaries
unlock blur

₹1.4 L/yr - ₹4 L/yr

Explore more salaries
Compare Mphasis with

Cognizant

3.7
Compare

Wipro

3.7
Compare

Accenture

3.7
Compare

TCS

3.6
Compare
write
Share an Interview