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 Verified Tick

Compare button icon Compare button icon Compare
3.7

based on 37.7k Reviews

Filter interviews by

Infosys Senior Plsql Developer Interview Questions and Answers

Updated 7 Aug 2024

Infosys Senior Plsql Developer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Explain cursors
  • Ans. 

    Cursors are used in PL/SQL to retrieve and process multiple rows from a result set.

    • Cursors are like pointers to a result set returned by a SELECT statement.

    • They allow us to fetch and process rows one by one.

    • Cursors are typically used in loops to iterate through the result set.

    • They can be explicit or implicit, with explicit cursors requiring more code.

    • Example: DECLARE cursor_name CURSOR FOR SELECT column1, column2 FROM

  • Answered by AI
  • Q2. Explain indexes
  • Ans. 

    Indexes are data structures that improve the speed of data retrieval operations on a database table.

    • Indexes are created on columns in a database table to quickly retrieve rows based on the values in those columns.

    • They can be unique, allowing only unique values to be stored in the indexed column.

    • Indexes can significantly improve the performance of SELECT queries but may slow down INSERT, UPDATE, and DELETE operations.

    • Ex...

  • Answered by AI

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Basic concepts related to DB

I applied via Recruitment Consultant and was interviewed in Nov 2021. There were 5 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Sal queries during initial first round Using cross join scenario
  • Q2. In managerial round they judge
  • Q3. Confidence and communication
  • Q4. At last in client round they asked collection questions and experience based questions what problems you have faced and how you resolve that etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Effective Comm skills plus sql ans plsql best practices
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I was interviewed before May 2023.

Round 1 - Aptitude Test 

Provide various round for aptitude test

Round 2 - Coding Test 

Provided various round of coding test questions

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
No response

I was interviewed before Jan 2024.

Round 1 - Technical 

(1 Question)

  • Q1. Technical questions and java coding
Round 2 - Behavioral 

(1 Question)

  • Q1. Technical + Hr process

Interview Preparation Tips

Interview preparation tips for other job seekers - Accenture now a days doing this SCAM, heard from many others as well about their experience. Sharing my experience, I have 3+ years of experience and interviewed for a position in Accenture. They took my first round on sept 30th 2024 and 1st round was cleared. Got communication that this position comprises of 2 round of interviews. But whole 1 month later I didn't get any communication from the panel. One day I got call that 2nd round will be scheduled immediately on the next day be prepared. They scheduled 2nd round on 22nd Nov (about 2months after 1st round). Got communication that my 2nd round was cleared too, means both rounds are cleared. 1 week later when I didn't get any communication from the company, I had to call the interview scheduler team,they said that now THAT POSITION HAS BEEN FILLED, THANKS FOR YOUR PATIENCE. Like 2 months of efforts to nothing, its like a harassment to the candidate. They further said that you can freshly apply for another role in their company.

Luckly I didn't keep hope only on this one company and cracked another company. But this is a very common SCAM happened with lot of my colleagues of my present company. Accenture say we are doing bulk hiring but behind this is a scam. Also HR process is worst of ACCENTURE.
We shall raise this concerns and higher management of Accenture should look into this issue.

Keep patience and definitely you will crack or switch to a good company. ALL THE BEST.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Dec 2024.

Round 1 - Technical 

(22 Questions)

  • Q1. API Gateway implementation
  • Q2. Circuit breaker implementation
  • Q3. What is deadlock? How to avoid it?
  • Q4. Explain equals() method
  • Q5. How mongodb was integrated in your application?
  • Q6. What is hibernate?
  • Q7. Runnable vs Callable interface
  • Q8. Which type of data is returned by Callable interface?
  • Q9. HashMap internal working
  • Q10. Concurrent HashMap internal working
  • Q11. How to monitor health of your application?
  • Q12. How to call an API in a Microservice architecture?
  • Q13. Explain Profiles
  • Q14. What is OpenFeign, and how is it used in microservices architecture?
  • Q15. What is the implementation process for service registry and discovery?
  • Q16. What are Spring boot actuators?
  • Q17. Synchronous vs Asynchronous communication
  • Q18. Explain Synchronized keyword
  • Q19. What are the consequences of excessively using synchronized blocks and methods in Java?
  • Q20. How can you determine the number of threads needed for your application?
  • Q21. Explain Executor framework
  • Q22. Explain BlockingQueue
Round 2 - HR 

(2 Questions)

  • Q1. Why did you leave your previous company?
  • Q2. Other basic questions asked regarding the relevant skills and technologies I have worked with.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Dec 2024. There were 5 interview rounds.

Round 1 - Aptitude Test 

An aptitude test is an assessment to measure a candidate mental aptitude/mental ability

Round 2 - Technical 

(3 Questions)

  • Q1. Can you briefly Tell us about yourself?
  • Ans. 

    I am a passionate software developer with 5 years of experience in web development and a strong background in computer science.

    • 5 years of experience in web development

    • Strong background in computer science

    • Passionate about software development

  • Answered by AI
  • Q2. What do you consider to be your strongest points?
  • Ans. 

    My strongest points include problem-solving skills, attention to detail, and ability to work well in a team.

    • Strong problem-solving skills - I enjoy tackling complex issues and finding creative solutions.

    • Attention to detail - I am meticulous in my work and strive for perfection in every task.

    • Team player - I collaborate effectively with colleagues, communicate openly, and contribute positively to group projects.

  • Answered by AI
  • Q3. Which programming languages do you use regularly in your work
  • Ans. 

    I regularly use Java, Python, and SQL in my work as a Software Developer.

    • Java

    • Python

    • SQL

  • Answered by AI
Round 3 - Group Discussion 

A group discussion is a structured conversation in which participants share their ideas, perspectives, and solutions on a specific topic.

Round 4 - HR 

(2 Questions)

  • Q1. What motivates you to seek employment at Wipro?
  • Ans. 

    I am motivated to seek employment at Wipro because of their reputation for innovation and opportunities for growth.

    • Impressed by Wipro's track record of delivering cutting-edge solutions

    • Excited about the chance to work with a diverse and talented team

    • Eager to take advantage of Wipro's professional development programs

  • Answered by AI
  • Q2. What are your long-term career goals?
  • Ans. 

    My long-term career goal is to become a lead software developer and eventually move into a management role.

    • Advance to a lead software developer position

    • Gain experience in managing a team of developers

    • Develop strong leadership and communication skills

    • Continue learning new technologies and staying updated with industry trends

  • Answered by AI
Round 5 - Assignment 

Assignment details refer to the specifics of an assignment, including any documents and/or emails or subsequent correspondence between the company and the client.

Interview Preparation Tips

Topics to prepare for Wipro Software Developer interview:
  • Your academic achievement
  • Responsibility related to your p
  • The way you address mistakes at
Interview preparation tips for other job seekers - Reflect on the activities you enjoy and what brings you happiness, while also taking into account your skills and strengths.
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Walk-in

Round 1 - Technical 

(2 Questions)

  • Q1. What are the types and number of constraints in your specific context?
  • Ans. 

    There are various types of constraints in DOT NET development, including primary key, foreign key, unique, check, and default constraints.

    • Primary key constraints ensure each record in a table is unique.

    • Foreign key constraints enforce referential integrity between tables.

    • Unique constraints ensure that all values in a column are distinct.

    • Check constraints validate the data before it is inserted or updated.

    • Default constra...

  • Answered by AI
  • Q2. What is the difference between an independent class and an abstract class?
  • Ans. 

    Independent class can be instantiated while abstract class cannot be instantiated directly.

    • Independent class can be directly instantiated using the 'new' keyword.

    • Abstract class cannot be instantiated directly, it can only be used as a base class for other classes.

    • Independent class does not require any derived class to implement its members.

    • Abstract class can have abstract methods that must be implemented by derived cla

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Technical coding with the technical team
Round 3 - HR 

(1 Question)

  • Q1. What are your reasons for changing your job?
  • Ans. 

    Seeking new challenges, growth opportunities, and a better work-life balance.

    • Looking for new challenges and opportunities to learn and grow.

    • Seeking a better work-life balance.

    • Interested in working with new technologies or in a different industry.

    • Wanting to advance my career and take on more responsibilities.

    • Company restructuring or changes in management.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It's important to prepare thoroughly in order to succeed in the interview.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Technical 

(2 Questions)

  • Q1. Different types of streams based questions
  • Q2. Collection , competable future, java 8 features
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Admin part and mainly LWC development
  • Q2. Case study on devlopment part
Round 2 - One-on-one 

(1 Question)

  • Q1. Last project details and more technical skills and real-time cases

Infosys Interview FAQs

How many rounds are there in Infosys Senior Plsql Developer interview?
Infosys interview process usually has 1 rounds. The most common rounds in the Infosys interview process are Technical.
What are the top questions asked in Infosys Senior Plsql Developer interview?

Some of the top questions asked at the Infosys Senior Plsql Developer interview -

  1. Explain curs...read more
  2. Explain inde...read more

Tell us how to improve this page.

Join Infosys Creating the next opportunity for people, businesses & communities

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.9
 • 8.1k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Capgemini Interview Questions
3.8
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.9
 • 3k Interviews
LTIMindtree Interview Questions
3.8
 • 3k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
View all
Infosys Senior Plsql Developer Salary
based on 8 salaries
₹7.3 L/yr - ₹12 L/yr
15% less than the average Senior Plsql Developer Salary in India
View more details
Technology Analyst
56.2k salaries
unlock blur

₹3 L/yr - ₹11 L/yr

Senior Systems Engineer
50k salaries
unlock blur

₹2.8 L/yr - ₹8 L/yr

System Engineer
39.2k salaries
unlock blur

₹2.5 L/yr - ₹5.5 L/yr

Technical Lead
30.7k salaries
unlock blur

₹5.2 L/yr - ₹19.5 L/yr

Senior Associate Consultant
27.3k salaries
unlock blur

₹4.3 L/yr - ₹16.8 L/yr

Explore more salaries
Compare Infosys with

TCS

3.7
Compare

Wipro

3.7
Compare

Cognizant

3.8
Compare

Accenture

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview