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
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;
/
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Job Portal and was interviewed before Mar 2023.
3 Interview Rounds
1
Technical Round (1 Question)
- Q1. Sql questions basic Add Answer
2
Technical Round (1 Question)
- Q1. Sql intermediate questions and jira and other daily tools Add Answer
3
HR Round (1 Question)
- Q1. Salary and other basic Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - as less experienced interview will be easy
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Indeed and was interviewed in Dec 2023.
3 Interview Rounds
1
Technical Round (1 Question)
- Q1. Simple question from your resume Add Answer
2
Coding Test Round
Coding related questions
3
HR Round (3 Questions)
- Q1. Tell me about yourself Add Answer
- Q2. What is your strength and weakness Add Answer
- Q3. Why are you want to join this question and what is your salary expectation Add Answer
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
I applied via Company Website
4 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
2
Aptitude Test Round
Basic questions were asked bt was of moderate level
3
Coding Test Round
One tree question (mandatory)
Optional basic problem
4
One-on-one Round (1 Question)
- Q1. Project discussion and c questions as well as basic of Java Add Answer
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
- Backend Developer Interview Questions
- Software Developer Intern 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
5%
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.3k
salaries
|  ₹4.1 L/yr - ₹17 L/yr |
|
Lead Consultant
4.5k
salaries
| ₹9 L/yr - ₹35.4 L/yr |
|
Associate Consultant
957
salaries
| ₹2.5 L/yr - ₹16.5 L/yr |
|
Software Engineer
560
salaries
| ₹3.5 L/yr - ₹14.6 L/yr |
|
Software Developer
397
salaries
| ₹3.1 L/yr - ₹12.5 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