Upload Button Icon Add office photos
Premium Employer

i

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

Infogain Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Infogain Plsql Developer Interview Questions and Answers

Updated 28 Oct 2023

Infogain Plsql Developer Interview Experiences

1 interview found

Interview experience
2
Poor
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 Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. Collection Related
  • Q2. Cursor Related Exmples

Interview questions from similar companies

Interview Questionnaire 

2 Questions

  • Q1. They have only one phone interview
  • Q2. They asking about full sql and plsql

Interview Preparation Tips

Round: Resume Shortlist
Experience: Detailed description of explaination full topics

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Basic SQL questions
  • Q2. Advanced PLSQL questions
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
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

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

Plsql Developer Interview Questions & Answers

Infosys 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 Resume 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

I applied via Approached by Company and was interviewed in Mar 2022. There were 3 interview rounds.

Round 1 - One-on-one 

(3 Questions)

  • Q1. What is a cursor. And its types
  • Ans. 

    A cursor is a database object used to retrieve data from a result set one row at a time.

    • Types of cursors: Implicit, Explicit, Ref, and Dynamic

    • Implicit cursor is used for single row queries

    • Explicit cursor is used for multi-row queries

    • Ref cursor is used to point to a cursor variable

    • Dynamic cursor is used to execute dynamic SQL statements

  • Answered by AI
  • Q2. Functions and procedures
  • Q3. Triggers and its types and syntax
  • Ans. 

    Explanation of triggers and their types in PL/SQL

    • Triggers are database objects that are automatically executed in response to certain events

    • Types of triggers include DML, DDL, and system triggers

    • Syntax for creating a trigger: CREATE [OR REPLACE] TRIGGER trigger_name {BEFORE|AFTER} {INSERT|UPDATE|DELETE} ON table_name [FOR EACH ROW] [WHEN condition] BEGIN ... END;

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. What is SQL optimization. Normalization. Pragma usage
  • Ans. 

    SQL optimization, normalization, and pragma usage are important concepts in PL/SQL development.

    • SQL optimization involves improving the performance of SQL queries by analyzing and modifying the query structure, indexes, and data access patterns.

    • Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Pragma is a compiler directive that provides additional information ...

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion, asked about having any other offer in hand

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up SQL queries and procedures, function, triggers

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.
Contribute & help others!
anonymous
You can choose to be anonymous

Infogain Interview FAQs

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

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

  1. Cursor Related Exmp...read more
  2. Collection Rela...read more

Recently Viewed

JOBS

Browse jobs

Discover jobs you love

JOBS

Browse jobs

Discover jobs you love

INTERVIEWS

Infogain

No Interviews

JOBS

Orange Business

No Jobs

JOBS

Kalyan Jewellers

No Jobs

DESIGNATION

INTERVIEWS

Infogain

No Interviews

JOBS

Tanisha Systems

No Jobs

INTERVIEWS

Infogain

No Interviews

JOBS

Zscaler Softech

No Jobs

Tell us how to improve this page.

Infogain Plsql Developer Interview Process

based on 1 interview

Interview experience

2
  
Poor
View more
Infogain Plsql Developer Salary
based on 12 salaries
₹3.5 L/yr - ₹13.5 L/yr
40% more than the average Plsql Developer Salary in India
View more details
Software Engineer
1.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Development Consultant
811 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Lead
613 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
458 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Consultant
373 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Infogain with

TCS

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare

Tech Mahindra

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview