Premium Employer
i
This company page is being actively managed by
Infosys Team. If you also belong to the team, you
can get access from
here
Infosys
Compare
Filter interviews by
Infosys Oracle SQL and PLSQL Developer Interview Questions, Process, and Tips
Updated
11 Nov 2024
Top Infosys Oracle SQL and PLSQL Developer Interview Questions and Answers
- Q1. Tell me about Analytical functions you worked on ?
- Q2. What is Context switching ? And about collection types ...
- Q3. What are Set operators ,which one keep duplicates among them
2 Infosys Oracle SQL and PLSQL Developer Interview Experiences
10 questions found
Sort by:
Popular
Anonymous
Interview experience
Poor
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Company Website
1 Interview Round
1
Technical Round (9 Questions)
- Q1. Question on LIST_AGGR Add Answer
- Q2. Question on dynamic SQL ,what is a bind variable Add Answer
- Q3. Question on constraints ,do we can delete a child table column having connection with foreign key with parent table Add Answer
- Q4. Triggers : do we can use commit or roll back with in trigger ? View Answers (1)
- Q5. Materialized views and how to refresh View Answers (1)
- Q6. Print 1 to 10 using sql View Answers (1)
- Q7. What is Context switching ? And about collection types ... View Answers (1)
- Q8. Tell me about Analytical functions you worked on ? View Answers (1)
- Q9. What are Set operators ,which one keep duplicates among them View Answers (1)
Interview Preparation Tips
Topics to prepare for Infosys Oracle SQL and PLSQL Developer interview:
- Siva academy
- Techtfq
- Kudvenkat
Skills evaluated in this interview
Get interview-ready with top interview questions
What people are saying about Infosys
View All
majesticravioli
works at
Infosys
Search feature of AmbitionBox
Is there no option to search for words that were mentioned in any of the posts in different communities in AmbitionBox? I can do the same in fishbowl but not sure if it is possible here
Got a question about Infosys?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I was interviewed in Sep 2024.
1 Interview Round
1
Technical Round (5 Questions)
- Q1. Tell me about OLAP systems. View Answers (1)
- Q2. How to process files in different formats and from different sources to load a single table in Oracle. View Answers (1)
- Q3. More questions on partitioning. Range and List partitioning. Interval partition, split partition etc Add Answer
- Q4. Questions on indexes Add Answer
- Q5. Questions on performance tuning Add Answer
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (1 Question)
- Q1. What is merge statement and use case ? View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
-
Duration
Less than 2 weeks
Result
Selected
I applied via Company Website and was interviewed in Apr 2023.
3 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
Coding Test Round
SQL and PLSQL querys writing.
3
HR Round (2 Questions)
- Q1. Self introduction ,and salary discussion Add Answer
- Q2. Self introduction and salary discussion, company details. Add Answer
Ani Anita
I applied via Walk-in and was interviewed in Feb 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
HR Round (1 Question)
- Q1. Tell me about yourself. Add Answer
Interview Preparation Tips
Topics to prepare for Wipro Oracle SQL and PLSQL Developer interview:
- Oracle SQL and plsql Developer
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (1 Question)
- Q1. What is sql , index , stored proc , triggers Add Answer
Interview experience
Good
Difficulty level
Easy
Duration
-
Result
-
I applied via Naukri.com and was interviewed in Apr 2024.
1 Interview Round
1
Technical Round (6 Questions)
- Q1. What is view? Can we update in view? View Answers (1)
- Q2. What is synonym? View Answers (1)
- Q3. What is sequence View Answers (1)
- Q4. What is procedures? View Answers (1)
- Q5. What is difference between procedure and functions View Answers (1)
- Q6. What is partitions? View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
HR Round (2 Questions)
- Q1. Tell about your self Add Answer
- Q2. Interested Technology Add Answer
2
Technical Round (2 Questions)
- Q1. What is SQL where it use View Answers (1)
- Q2. What is Join and Procedure View Answers (1)
Skills evaluated in this interview
Interview experience
Poor
Difficulty level
Moderate
Duration
-
Result
Not Selected
I applied via Naukri.com and was interviewed in May 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. How to insert multiple values in one go View Answers (1)
- Q2. Update query using joins View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare Basic Questions
Skills evaluated in this interview
Infosys Interview FAQs
How many rounds are there in Infosys Oracle SQL and PLSQL Developer interview?
Infosys interview process usually has 1 rounds. The most common rounds in the Infosys interview process are Technical.
How to prepare for Infosys Oracle SQL and 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 Infosys. The most common topics and skills that interviewers at Infosys expect are Apex, Oracle SQL and PLSQL.
What are the top questions asked in Infosys Oracle SQL and PLSQL Developer interview?
Tell us how to improve this page.
Infosys Interviews By Designations
- Infosys System Engineer Interview Questions
- Infosys Software Engineer Interview Questions
- Infosys Technology Analyst Interview Questions
- Infosys Senior Systems Engineer Interview Questions
- Infosys Associate Consultant Interview Questions
- Infosys Software Developer Interview Questions
- Infosys Business Analyst Interview Questions
- Infosys Senior Associate Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Plsql Developer Interview Questions
- Senior Plsql Developer Interview Questions
- SQL Developer Interview Questions
- SQL Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- SQL and PL SQL Developer Interview Questions
- SQL Server Developer Interview Questions
- SQL Server Database Administrator Interview Questions
- Show more
People are getting interviews through
based on 1 Infosys interview
Company Website
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Join Infosys Creating the next opportunity for people, businesses & communities
Interview Questions from Similar Companies
Fast track your campus placements
At
par with the average Oracle SQL and PLSQL Developer Salary in India
View more details
Infosys Oracle SQL and PLSQL Developer Reviews and Ratings
based on 1 review
Rating in categories
|
Technology Analyst
57.4k
salaries
|  ₹3 L/yr - ₹11 L/yr |
|
Senior Systems Engineer
49.9k
salaries
| ₹2.5 L/yr - ₹8 L/yr |
|
System Engineer
32.8k
salaries
| ₹2 L/yr - ₹5 L/yr |
|
Technical Lead
31.4k
salaries
| ₹5.3 L/yr - ₹19.5 L/yr |
|
Senior Associate Consultant
27.3k
salaries
| ₹6.2 L/yr - ₹18 L/yr |
Explore more salaries
Compare Infosys with
TCS
Compare
Wipro
Compare
Cognizant
Compare
Accenture
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 >
- Infosys Interview Questions >
- Infosys Oracle SQL and PLSQL Developer Interview Questions
Share an Interview