Premium Employer

i

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

Infosys Verified Tick Work with us arrow

Compare button icon Compare button icon Compare

Filter interviews by

Infosys Plsql Developer Interview Questions and Answers

Updated 13 Jan 2025

14 Interview questions

🔥 Asked by recruiter 2 times
A Plsql Developer was asked 5mo ago
Q. What is the difference between SQL and PL/SQL?
Ans. 

SQL is a query language used to interact with databases, while PL/SQL is a procedural language extension for SQL.

  • SQL is used for querying and manipulating data in databases.

  • PL/SQL is used for writing procedural code like loops, conditions, and functions.

  • SQL statements are executed one at a time, while PL/SQL blocks can contain multiple statements.

  • SQL is declarative, while PL/SQL is procedural.

  • Example: SQL - SELECT...

A Plsql Developer was asked 6mo ago
Q. Tell me about regular expressions.
Ans. 

Regular expressions (regex) are sequences of characters that define search patterns for strings, used for pattern matching and manipulation.

  • Regex is used for validating input formats, e.g., email addresses: ^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$

  • It can extract specific patterns from text, such as phone numbers: \d{3}-\d{3}-\d{4}

  • Regex supports various metacharacters like '.', '*', and '+', which have speci...

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 8mo ago
Q. What are packages and types?
Ans. 

Packages and types are two important components in PL/SQL used for organizing and defining reusable code and data structures.

  • Packages are containers for related procedures, functions, variables, and other PL/SQL constructs.

  • Types are user-defined data structures that can be used to define new data types in PL/SQL.

  • Packages can contain types as well as other PL/SQL constructs, providing a way to organize and encapsul...

A Plsql Developer was asked 10mo ago
Q. What is exception handling, and what is its syntax?
Ans. 

Exception handling is a mechanism to handle errors or unexpected events in a program.

  • Syntax: BEGIN -- code block EXCEPTION -- exception handling block END;

  • Exceptions can be predefined or user-defined

  • Common predefined exceptions include NO_DATA_FOUND, TOO_MANY_ROWS, etc.

  • User-defined exceptions can be declared using the EXCEPTION keyword

A Plsql Developer was asked 10mo ago
Q. What is performance tuning?
Ans. 

Performance tuning is the process of optimizing the speed and efficiency of a system or application.

  • Identifying and resolving bottlenecks in the system

  • Optimizing SQL queries and database design

  • Improving code efficiency and reducing resource usage

  • Monitoring system performance and making adjustments as needed

A Plsql Developer was asked 10mo ago
Q. What is a cursor and what are its attributes?
Ans. 

A cursor is a pointer to a result set for a SQL query. It allows you to iterate through the rows of the result set.

  • Cursors are used in PL/SQL to process individual rows returned by a query.

  • Attributes of a cursor include %NOTFOUND, %FOUND, %ROWCOUNT, and %ISOPEN.

  • Example: OPEN cursor_name; FETCH cursor_name INTO variable; CLOSE cursor_name;

A Plsql Developer was asked 10mo ago
Q. How do you delete duplicates from the same table?
Ans. 

Use a self-join query to delete duplicates from the same table.

  • Use a self-join query to identify the duplicate records based on a unique identifier column.

  • Delete the duplicate records using the DELETE statement with the self-join condition.

Are these interview questions helpful?
A Plsql Developer was asked 10mo ago
Q. What are triggers, and what is their syntax?
Ans. 

Triggers are PL/SQL blocks that are automatically executed when certain events occur on a table.

  • Triggers can be used to enforce business rules, audit changes, or maintain data integrity.

  • Syntax: CREATE OR REPLACE TRIGGER trigger_name BEFORE/AFTER INSERT/UPDATE/DELETE ON table_name FOR EACH ROW BEGIN -- trigger logic here END;

A Plsql Developer was asked 10mo ago
Q. Write a merge statement in PL/SQL.
Ans. 

Merge statement in PL/SQL combines insert and update operations based on a condition.

  • Use MERGE INTO statement followed by target table name

  • Specify USING clause with source table or subquery

  • Define ON condition to match rows for update or insert

  • Use WHEN MATCHED THEN UPDATE SET for update operation

  • Use WHEN NOT MATCHED THEN INSERT VALUES for insert operation

A Plsql Developer was asked
Q. Explain exception handling, including named and unnamed exceptions. Provide examples of exception names.
Ans. 

Named and unnamed exceptions in PL/SQL with examples

  • Named exceptions are user-defined exceptions with specific names like 'custom_exception'

  • Unnamed exceptions are predefined exceptions like 'NO_DATA_FOUND' or 'TOO_MANY_ROWS'

  • Named exceptions can be raised using RAISE statement with the exception name

  • Unnamed exceptions are raised automatically by the system in case of errors

  • Example of named exception: DECLARE custom...

Infosys Plsql Developer Interview Experiences

10 interviews found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I appeared for an interview in Nov 2024.

Round 1 - Technical 

(4 Questions)

  • Q1. Types of partition in sql
  • Q2. Can we edit data in complex views, will the underlying table be effected?
  • Ans. 

    Editing data in complex views can affect underlying tables, but it depends on the view's structure and rules.

    • Complex views often involve joins, aggregations, or groupings, making them non-updatable.

    • If a view is updatable, changes made to it will reflect in the underlying tables.

    • Example: A simple view on a single table can be updated directly.

    • Example: A view that aggregates data (e.g., SUM, COUNT) cannot be updated dire...

  • Answered by AI
  • Q3. How do you do performance tuning?
  • Ans. 

    Performance tuning involves optimizing database queries and configurations for improved efficiency and speed.

    • Analyze execution plans to identify slow queries. For example, use EXPLAIN PLAN to see how Oracle executes a query.

    • Use indexing strategically. For instance, create indexes on columns frequently used in WHERE clauses to speed up data retrieval.

    • Optimize SQL queries by avoiding SELECT *, using WHERE clauses effecti...

  • Answered by AI
  • Q4. Tell about regex
  • Ans. 

    Regular expressions (regex) are sequences of characters that define search patterns for strings, used for pattern matching and manipulation.

    • Regex is used for validating input formats, e.g., email addresses: ^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$

    • It can extract specific patterns from text, such as phone numbers: \d{3}-\d{3}-\d{4}

    • Regex supports various metacharacters like '.', '*', and '+', which have special me...

  • Answered by AI
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. What is the difference between SQL and PL/SQL?
  • Ans. 

    SQL is a query language used to interact with databases, while PL/SQL is a procedural language extension for SQL.

    • SQL is used for querying and manipulating data in databases.

    • PL/SQL is used for writing procedural code like loops, conditions, and functions.

    • SQL statements are executed one at a time, while PL/SQL blocks can contain multiple statements.

    • SQL is declarative, while PL/SQL is procedural.

    • Example: SQL - SELECT * FR...

  • Answered by AI
  • Q2. How can distinct values be obtained without using the DISTINCT keyword?
  • Ans. 

    Using GROUP BY clause with aggregate functions can obtain distinct values without using the DISTINCT keyword.

    • Use GROUP BY clause with aggregate functions like COUNT, SUM, AVG, etc.

    • Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name;

  • Answered by AI
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(7 Questions)

  • Q1. How to delete duplicates from same table
  • Ans. 

    Use a self-join query to delete duplicates from the same table.

    • Use a self-join query to identify the duplicate records based on a unique identifier column.

    • Delete the duplicate records using the DELETE statement with the self-join condition.

  • Answered by AI
  • Q2. Write a query to display 5th max salary
  • Ans. 

    Query to display 5th max salary in a table

    • Use the RANK() function to assign a rank to each salary

    • Filter the results to only show the row with rank 5

    • Order the salaries in descending order to get the 5th max salary

  • Answered by AI
  • Q3. What is cursor and its attributes
  • Ans. 

    A cursor is a pointer to a result set for a SQL query. It allows you to iterate through the rows of the result set.

    • Cursors are used in PL/SQL to process individual rows returned by a query.

    • Attributes of a cursor include %NOTFOUND, %FOUND, %ROWCOUNT, and %ISOPEN.

    • Example: OPEN cursor_name; FETCH cursor_name INTO variable; CLOSE cursor_name;

  • Answered by AI
  • Q4. What is exception handling and write its syntax
  • Ans. 

    Exception handling is a mechanism to handle errors or unexpected events in a program.

    • Syntax: BEGIN -- code block EXCEPTION -- exception handling block END;

    • Exceptions can be predefined or user-defined

    • Common predefined exceptions include NO_DATA_FOUND, TOO_MANY_ROWS, etc.

    • User-defined exceptions can be declared using the EXCEPTION keyword

  • Answered by AI
  • Q5. What is performance tuning
  • Ans. 

    Performance tuning is the process of optimizing the speed and efficiency of a system or application.

    • Identifying and resolving bottlenecks in the system

    • Optimizing SQL queries and database design

    • Improving code efficiency and reducing resource usage

    • Monitoring system performance and making adjustments as needed

  • Answered by AI
  • Q6. Write merge statement in plsql
  • Ans. 

    Merge statement in PL/SQL combines insert and update operations based on a condition.

    • Use MERGE INTO statement followed by target table name

    • Specify USING clause with source table or subquery

    • Define ON condition to match rows for update or insert

    • Use WHEN MATCHED THEN UPDATE SET for update operation

    • Use WHEN NOT MATCHED THEN INSERT VALUES for insert operation

  • Answered by AI
  • Q7. What are triggers and write its syntax
  • Ans. 

    Triggers are PL/SQL blocks that are automatically executed when certain events occur on a table.

    • Triggers can be used to enforce business rules, audit changes, or maintain data integrity.

    • Syntax: CREATE OR REPLACE TRIGGER trigger_name BEFORE/AFTER INSERT/UPDATE/DELETE ON table_name FOR EACH ROW BEGIN -- trigger logic here END;

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare for coding also

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. What is packages and types
  • Ans. 

    Packages and types are two important components in PL/SQL used for organizing and defining reusable code and data structures.

    • Packages are containers for related procedures, functions, variables, and other PL/SQL constructs.

    • Types are user-defined data structures that can be used to define new data types in PL/SQL.

    • Packages can contain types as well as other PL/SQL constructs, providing a way to organize and encapsulate r...

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. Sql loader questions - Give command
  • Ans. 

    SQL Loader is a tool for loading data from external files into Oracle databases efficiently.

    • Use the command: sqlldr userid=username/password control=control_file.ctl

    • Control file specifies the format of the data file and how to load it.

    • Example control file: LOAD DATA INFILE 'data.csv' INTO TABLE my_table FIELDS TERMINATED BY ','

    • SQL Loader supports various data formats like CSV, fixed-width, etc.

    • You can use options like ...

  • Answered by AI
  • Q2. Difference in procedure and function
  • Ans. 

    Procedure is used to perform an action, while function returns a value.

    • Procedure does not return a value, while function does

    • Functions can be used in SQL queries, procedures cannot

    • Functions can be called from SQL statements, procedures cannot

  • Answered by AI
  • Q3. What is init in performance tuning?
  • Ans. 

    In performance tuning, init refers to the initialization parameter file used by Oracle Database to configure various settings.

    • init is a text-based configuration file that contains parameters to optimize the performance of Oracle Database.

    • It is used to set parameters such as memory allocation, parallel processing, and resource utilization.

    • By tuning the init file, developers can improve the overall performance of the dat...

  • Answered by AI
  • Q4. Exception handling - Named and unnamed. Give exceptions names.
  • Ans. 

    Named and unnamed exceptions in PL/SQL with examples

    • Named exceptions are user-defined exceptions with specific names like 'custom_exception'

    • Unnamed exceptions are predefined exceptions like 'NO_DATA_FOUND' or 'TOO_MANY_ROWS'

    • Named exceptions can be raised using RAISE statement with the exception name

    • Unnamed exceptions are raised automatically by the system in case of errors

    • Example of named exception: DECLARE custom_exce...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just know the basics. But Infosys keeps people waiting in queue for months before giving out the results.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Question based on PLSQL
  • Q2. What is Execution Plan, Query Optimization
  • Ans. 

    Execution plan is a roadmap created by the database optimizer to determine the most efficient way to execute a query.

    • Execution plan shows the steps the database will take to execute a query.

    • Query optimization involves finding the most efficient way to execute a query.

    • Optimization techniques include index usage, join methods, and access paths.

    • Understanding execution plans helps in tuning queries for better performance.

  • Answered by AI
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Types of cursors
  • Ans. 

    Types of cursors include implicit, explicit, and parameterized cursors.

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

    • Explicit cursors are defined by the programmer using the DECLARE, OPEN, FETCH, and CLOSE statements.

    • Parameterized cursors allow for dynamic SQL statements to be executed with different parameters.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare plsql topics well.

Skills evaluated in this interview

Plsql Developer Interview Questions & Answers

user image Bvm Bharath Kumar

posted on 14 Oct 2023

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 

(2 Questions)

  • Q1. Dif between SQL n plsql
  • Ans. 

    SQL is a query language used to interact with databases, while PL/SQL is a procedural language extension for SQL.

    • SQL is used for querying and manipulating data in databases.

    • PL/SQL is used for writing procedural code like loops, conditions, and functions.

    • SQL statements are executed one at a time, while PL/SQL blocks can contain multiple statements.

    • PL/SQL can be used to create stored procedures, functions, and triggers i...

  • Answered by AI
  • Q2. Structure query language and extension version of sql
  • Ans. 

    SQL is a structured query language used to communicate with databases. SQL extensions add additional functionality to the language.

    • SQL is a standard language used to interact with databases

    • SQL extensions like PL/SQL add procedural programming capabilities to SQL

    • PL/SQL is an extension of SQL used in Oracle databases

  • Answered by AI

Skills evaluated in this interview

Round 1 - Technical 

(3 Questions)

  • Q1. SQL queries, joins, views, functions , advanced functions, exceptions.. Lot of Scenario based question
  • Q2. About resume and past experiences
  • Q3. Interview happened almost 1hr
Round 2 - HR 

(1 Question)

  • Q1. After 30 days.. Do u have any other offer in hand? How much they offered

Interview Preparation Tips

Interview preparation tips for other job seekers - After 30 days after n number of follow up mail
Hr discussion happened. Which was surprising one. The package they offfered is very less for an experienced candidate .. It doesn't even have 20%hike from current salary.

I applied via Naukri.com and was interviewed in Nov 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Procedure, function, bulk collect,

Interview Preparation Tips

Interview preparation tips for other job seekers - We have to be confidence while answering.they are checking ur ability

What people are saying about Infosys

View All
yedabhai
2d
works at
Hyperpure
Are we not even safe in our own workplaces?
An Infosys employee was arrested for secretly recording women in the office washroom. Over 30 videos were found on his phone. This isn't just shocking, it's horrifying. Offices are meant to be safe, respectful spaces. 🙎 When will companies truly prioritize safety and surveillance in all corners, not just the visible ones?
FeedCard Image
Got a question about Infosys?
Ask anonymously on communities.

Infosys Interview FAQs

How many rounds are there in Infosys Plsql Developer interview?
Infosys interview process usually has 1-2 rounds. The most common rounds in the Infosys interview process are Technical, HR and Resume Shortlist.
How to prepare for Infosys 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 Infosys. The most common topics and skills that interviewers at Infosys expect are PLSQL, SQL, Oracle, Oracle SQL and SDLC.
What are the top questions asked in Infosys Plsql Developer interview?

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

  1. How can distinct values be obtained without using the DISTINCT keywo...read more
  2. Can we edit data in complex views, will the underlying table be effect...read more
  3. what is exception handling and write its syn...read more

Tell us how to improve this page.

Overall Interview Experience Rating

3.3/5

based on 8 interview experiences

Difficulty level

Easy 25%
Moderate 75%

Duration

Less than 2 weeks 75%
2-4 weeks 25%
View more
Join Infosys Creating the next opportunity for people, businesses & communities
Infosys Plsql Developer Salary
based on 247 salaries
₹8.7 L/yr - ₹15 L/yr
82% more than the average Plsql Developer Salary in India
View more details

Infosys Plsql Developer Reviews and Ratings

based on 20 reviews

4.5/5

Rating in categories

4.1

Skill development

4.2

Work-life balance

3.9

Salary

4.0

Job security

4.1

Company culture

3.6

Promotions

3.9

Work satisfaction

Explore 20 Reviews and Ratings
RestartWithInfosys (Java/.net/Mainframe/Python/PLSQL Developer)

Bangalore / Bengaluru

5-10 Yrs

Not Disclosed

PLSQL Developer

Bangalore / Bengaluru

3-5 Yrs

₹ 3.7-13 LPA

PLSQL Developer

Pune

3-5 Yrs

₹ 3.8-9.2 LPA

Explore more jobs
Technology Analyst
54.7k salaries
unlock blur

₹4.8 L/yr - ₹10 L/yr

Senior Systems Engineer
53.8k salaries
unlock blur

₹2.5 L/yr - ₹6.3 L/yr

Technical Lead
35.1k salaries
unlock blur

₹9.4 L/yr - ₹16.4 L/yr

System Engineer
32.5k salaries
unlock blur

₹2.4 L/yr - ₹5.5 L/yr

Senior Associate Consultant
31.2k salaries
unlock blur

₹8.2 L/yr - ₹14 L/yr

Explore more salaries
Compare Infosys with

TCS

3.6
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare

Accenture

3.7
Compare
write
Share an Interview