Add office photos
Filter interviews by
IAP Company Plsql Developer Interview Questions and Answers
Updated
8 Jun 2021
1 interview found
Sort by:
Popular
Anonymous
Interview Questions
- Q1. What is cursor? What is trigger & trigger performance
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
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 experience
Average
Difficulty level
Easy
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Apr 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. RANK, WITH CLAUSE, PARTITION, DISTINCT, REF CURSOR Add Answer
- Q2. Procedure with Ref cursor
AVG, EXISTS, write a block to find factorial View Answers (1)
- Q3. Handle duplicate records with case statement View Answers (1)
- Q4. Joins, DBMS_PROFILER Add Answer
Skills evaluated in this interview
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
Sabarish R
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Basic SQL questions Add Answer
- Q2. Advanced PLSQL questions Add Answer
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
Venkatesh Ganesh
I applied via Naukri.com and was interviewed in Jun 2022.
2 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
One-on-one Round (2 Questions)
- Q1. Triggers ,
procedures ,
exception handling ,
collections,
package Add Answer
- Q2. Type , array, partition, performance tuning, AWR Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - For senior level they will expect knowledge on bulk processing exception handling packages collections
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
Tell us how to improve this page.
IAP Company Interviews By Designations
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
Plsql Developer Interview Questions from Similar Companies
|
Senior Programmer
7
salaries
|  ₹2 L/yr - ₹9 L/yr |
|
Programmer
6
salaries
| ₹1.8 L/yr - ₹3.4 L/yr |
|
Assistant Manager
5
salaries
| ₹5.6 L/yr - ₹5.8 L/yr |
|
Assistant Programmer
5
salaries
| ₹1.2 L/yr - ₹2 L/yr |
|
Software Developer
4
salaries
| ₹2.6 L/yr - ₹15.5 L/yr |
Explore more salaries
Compare IAP Company with
Cognizant
Compare
NTT Data Information Processing Services
Compare
Sutherland Global Services
Compare
Hexaware Technologies
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 >
- IAP Company Interview Questions >
- IAP Company Plsql Developer Interview Questions
Share an Interview