Upload Button Icon Add office photos
Engaged Employer

i

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

ITC Infotech Verified Tick

Compare button icon Compare button icon Compare
3.8

based on 3.5k Reviews

Filter interviews by

ITC Infotech Plsql Developer Interview Questions, Process, and Tips

Updated 3 Oct 2024

ITC Infotech Plsql Developer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Technical 

(4 Questions)

  • Q1. How do you optimize Stored procedure
  • Ans. 

    Optimizing stored procedures involves using proper indexing, reducing unnecessary loops, and minimizing database calls.

    • Use proper indexing on columns used in WHERE clauses to improve query performance

    • Avoid using cursors and loops whenever possible, as they can be inefficient

    • Minimize the number of database calls by combining multiple queries into a single query or using temporary tables

    • Consider using bulk processing tec...

  • Answered by AI
  • Q2. How do you optimize SQL query
  • Ans. 

    Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.

    • Use indexes on columns frequently used in WHERE clauses

    • Minimize data retrieval by selecting only necessary columns

    • Avoid unnecessary joins by using EXISTS or IN clauses instead

    • Optimize query structure by using appropriate join types and conditions

  • Answered by AI
  • Q3. What is use of returning clause
  • Ans. 

    Returning clause is used to return a value from a function or procedure in PL/SQL.

    • Used to return a single value from a function or procedure

    • Can be used to return multiple values using OUT parameters

    • Helps in passing values back to the calling program

  • Answered by AI
  • Q4. Disadvantages of triggers
  • Ans. 

    Triggers can lead to performance issues, complexity, and potential for unintended consequences.

    • Triggers can make code harder to debug and maintain

    • They can lead to cascading effects if not carefully implemented

    • Performance can be impacted if triggers are not optimized

    • Triggers can introduce dependencies between different parts of the codebase

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

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
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
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Monster

Round 1 - Technical 

(3 Questions)

  • Q1. Write query to get result based on hughest salary
  • Ans. 

    Use SQL query with ORDER BY clause to get result based on highest salary

    • Use SELECT statement to retrieve data from the table

    • Use ORDER BY clause with DESC keyword to sort salaries in descending order

    • Use LIMIT or FETCH FIRST clause to limit the result to only one row

  • Answered by AI
  • Q2. Writw merge query
  • Q3. Bulk collect and bulk binding difference
  • Ans. 

    Bulk collect is used to fetch multiple rows into collections at once, while bulk binding is used to bind collections to SQL statements for improved performance.

    • Bulk collect fetches multiple rows into collections in a single operation, reducing context switches and improving performance.

    • Bulk binding binds collections to SQL statements, reducing the number of context switches between the PL/SQL engine and SQL engine.

    • Bulk...

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Job Portal

Round 1 - HR 

(1 Question)

  • Q1. What is plsql and sql
  • Ans. 

    PL/SQL is a procedural extension of SQL used for writing stored procedures, functions, triggers, and packages in Oracle databases.

    • PL/SQL stands for Procedural Language/Structured Query Language

    • It is used to write procedural code like stored procedures, functions, triggers, and packages in Oracle databases

    • SQL (Structured Query Language) is a standard language for accessing and manipulating databases

    • SQL is used to query,...

  • Answered by AI
Round 2 - Coding Test 

Questions on plsql and sql in general

Skills evaluated in this interview

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

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Case Study 

JOINS DIFFERENCE BETWEEEN (LEFT,RIGHT,INNER,FULL)

Round 3 - Coding Test 

CREATE OR REPLACE PROCEDURE PP(A NUMBER) IS
BEGIN
DBMS_OUTPUT.PUT_LINE(A);
END;
/

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Jul 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Easy exam sample available on youtube

Round 2 - Technical 

(2 Questions)

  • Q1. What are step functions.
  • Ans. 

    Step functions are a type of serverless function that allow you to create workflows by chaining multiple functions together.

    • Step functions are used to coordinate multiple AWS services into serverless workflows.

    • They allow you to define a series of steps in a workflow, with each step being a separate function.

    • You can use step functions to handle complex business logic, long-running processes, and error handling.

    • Step func...

  • Answered by AI
  • Q2. How to scale lambdas
  • Ans. 

    Scaling lambdas involves optimizing memory usage, increasing concurrency, and managing dependencies.

    • Optimize memory usage by reducing unnecessary variables and objects

    • Increase concurrency by using asynchronous programming and parallel processing

    • Manage dependencies by breaking down functions into smaller, more modular components

    • Consider using AWS Lambda Provisioned Concurrency for consistent performance

  • Answered by AI
Round 3 - Behavioral 

(1 Question)

  • Q1. How did you handled a difficult collegelue
  • Ans. 

    I addressed the issue directly and professionally, seeking to understand their perspective and find common ground.

    • Approached the colleague privately to discuss the issue

    • Listened actively to their concerns and perspective

    • Sought to find common ground and reach a resolution

    • Maintained professionalism and respect throughout the conversation

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Managerial round. Behavioral and cloud technology scenario based questions. Interviewer very friendly and open

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Write the code in eggplant
  • Ans. 

    Writing code in eggplant for Senior Developer interview

    • Use 'click' to simulate a mouse click on an element

    • Use 'typeText' to enter text into a field

    • Use 'verify' to check if an element is present on the screen

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

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

Round 1 - Technical 

(2 Questions)

  • Q1. CSS Box-model definition
  • Ans. 

    CSS Box-model defines how elements are rendered in a webpage, including padding, border, and margin.

    • Box-model consists of content, padding, border, and margin

    • Content area is where text or images are displayed

    • Padding is the space between content and border

    • Border is the line around the content and padding

    • Margin is the space outside the border

  • Answered by AI
  • Q2. Difference b/n flexbox and grid
  • Ans. 

    Flexbox is for one-dimensional layouts, grid is for two-dimensional layouts.

    • Flexbox is best for arranging items in a single row or column.

    • Grid is best for creating complex layouts with rows and columns.

    • Flexbox is more suitable for smaller scale layouts, while grid is better for larger scale layouts.

    • Flexbox is more flexible in terms of item order and sizing, while grid provides more control over the overall layout.

    • Both

  • Answered by AI

Skills evaluated in this interview

ITC Infotech Interview FAQs

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

Some of the top questions asked at the ITC Infotech Plsql Developer interview -

  1. How do you optimize Stored proced...read more
  2. What is use of returning cla...read more
  3. How do you optimize SQL qu...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 ITC Infotech interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
ITC Infotech Plsql Developer Salary
based on 34 salaries
₹3 L/yr - ₹10.3 L/yr
At par with the average Plsql Developer Salary in India
View more details

ITC Infotech Plsql Developer Reviews and Ratings

based on 3 reviews

4.5/5

Rating in categories

3.9

Skill development

4.0

Work-Life balance

3.9

Salary & Benefits

4.5

Job Security

4.5

Company culture

3.9

Promotions/Appraisal

3.9

Work Satisfaction

Explore 3 Reviews and Ratings
Associate Information Technology Consultant
5.2k salaries
unlock blur

₹4.1 L/yr - ₹15 L/yr

Lead Consultant
4.4k salaries
unlock blur

₹9 L/yr - ₹35.4 L/yr

Associate Consultant
850 salaries
unlock blur

₹2.5 L/yr - ₹16.5 L/yr

Software Engineer
497 salaries
unlock blur

₹4 L/yr - ₹14 L/yr

Senior Software Engineer
366 salaries
unlock blur

₹6.2 L/yr - ₹27 L/yr

Explore more salaries
Compare ITC Infotech with

TCS

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare

Tech Mahindra

3.6
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview