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
Compare
Filter interviews by
ITC Infotech Plsql Developer Interview Questions, Process, and Tips
Updated
3 Oct 2024
1 ITC Infotech Plsql Developer Interview Experience
4 questions found
Sort by:
Popular
Anonymous
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Sep 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. How do you optimize Stored procedure View Answers (1)
- Q2. How do you optimize SQL query View Answers (1)
- Q3. What is use of returning clause View Answers (1)
- Q4. Disadvantages of triggers View Answers (1)
Skills evaluated in this interview
Top trending discussions
View All
Salary Discussions, Hike & Promotions
2w
a senior consultant
Retention offer
Hello,
Current offer from CG - Total 21.5L, fixed as 19.4 and rest bonus
Retention offer from Deloitte - Total 19.1, fixed as 15.5 and rest bonus (4L)
I understand the offer is less but my manager explained that Deloitte's hikes are better in the market and on an average, I can get 15% every year with good performance.
The same hikes in CG are around 5-6% so financially, my salary growth will definitely be more in Deloitte.
Please give me suggestions. I have good management and projects in Deloitte with WLB but I would like to have some perspective on offered CTC too
Got a question about ITC Infotech ?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Oct 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. EXPLAIN ABOUT UR PRJECT View Answers (1)
- Q2. How do you work on performance optimization View Answers (1)
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
One-on-one Round (2 Questions)
- Q1. CREATE A FUNCTION BASED ONLOGIC SHARED View Answers (1)
- Q2. FOR AN ENTITY GIVE DTAILS OF PREVOUS AND NEXT DATE FOR PARTICULAR DEPATMENT Add Answer
Interview experience
Poor
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Monster
1 Interview Round
1
Technical Round (3 Questions)
- Q1. Write query to get result based on hughest salary View Answers (1)
- Q2. Writw merge query Add Answer
- Q3. Bulk collect and bulk binding difference View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
I applied via Job Portal
2 Interview Rounds
1
HR Round (1 Question)
- Q1. What is plsql and sql View Answers (1)
2
Coding Test Round
Questions on plsql and sql in general
Skills evaluated in this interview
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Resume Shortlist Round
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
2
Technical Round (4 Questions)
- Q1. Difference between delete, drop and truncate View Answers (1)
- Q2. Difference between table and view View Answers (1)
- Q3. What type of cursors did you use View Answers (1)
- Q4. What is primary key and unique key View Answers (1)
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
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
Excellent
Difficulty level
-
Duration
-
Result
-
3 Interview Rounds
1
Resume Shortlist Round
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
2
Case Study Round
JOINS DIFFERENCE BETWEEEN (LEFT,RIGHT,INNER,FULL)
3
Coding Test Round
CREATE OR REPLACE PROCEDURE PP(A NUMBER) IS
BEGIN
DBMS_OUTPUT.PUT_LINE(A);
END;
/
Aswathi R Nair
Interview experience
Average
Difficulty level
Moderate
Duration
4-6 weeks
Result
Not Selected
I applied via Company Website and was interviewed in Jul 2024.
3 Interview Rounds
1
Aptitude Test Round
Easy exam sample available on youtube
2
Technical Round (2 Questions)
- Q1. What are step functions. View Answers (1)
- Q2. How to scale lambdas View Answers (1)
3
Behavioral Round (1 Question)
- Q1. How did you handled a difficult collegelue View Answers (1)
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
Yogi Sumanth Rao
Interview experience
Poor
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (1 Question)
- Q1. Write the code in eggplant View Answers (1)
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in May 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. CSS Box-model definition View Answers (1)
- Q2. Difference b/n flexbox and grid View Answers (1)
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.
Tell us how to improve this page.
ITC Infotech Interviews By Designations
- ITC Infotech Associate Information Technology Consultant Interview Questions
- ITC Infotech Lead Consultant Interview Questions
- ITC Infotech Associate Consultant Interview Questions
- ITC Infotech Software Developer Interview Questions
- ITC Infotech IT Consultant Interview Questions
- ITC Infotech Associate IT Consultant 2 Interview Questions
- ITC Infotech Software Engineer Interview Questions
- ITC Infotech Java Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle SQL and PLSQL Developer Interview Questions
- Senior Plsql Developer Interview Questions
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Software Developer Intern Interview Questions
- Backend Developer Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- Show more
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.
Plsql Developer Interview Questions from Similar Companies
Fast track your campus placements
6%
less
than the average Plsql Developer Salary in India
View more details
ITC Infotech Plsql Developer Reviews and Ratings
based on 3 reviews
Rating in categories
|
Associate Information Technology Consultant
5.2k
salaries
|  ₹4.1 L/yr - ₹15 L/yr |
|
Lead Consultant
4.4k
salaries
| ₹9 L/yr - ₹35.4 L/yr |
|
Associate Consultant
850
salaries
| ₹2.5 L/yr - ₹16.2 L/yr |
|
Software Engineer
500
salaries
| ₹4 L/yr - ₹16 L/yr |
|
Software Developer
362
salaries
| ₹3 L/yr - ₹13 L/yr |
Explore more salaries
Compare ITC Infotech with
TCS
Compare
Wipro
Compare
HCLTech
Compare
Tech Mahindra
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
- Home >
- Interviews >
- ITC Infotech Interview Questions >
- ITC Infotech Plsql Developer Interview Questions
Share an Interview