AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Infosys
Compare
Filter interviews by
Clear (1)
Infosys Oracle SQL and PLSQL Developer Interview Questions, Process, and Tips
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
Infosys Oracle SQL and PLSQL Developer Interview Experiences
2 interviews found
Anonymous
I applied via Company Website
(9 Questions)
- Q1. Question on LIST_AGGR
- Q2. Question on dynamic SQL ,what is a bind variable
- Q3. Question on constraints ,do we can delete a child table column having connection with foreign key with parent table
- Q4. Triggers : do we can use commit or roll back with in trigger ?
- Ans.
No, we cannot use commit or roll back within a trigger.
Triggers are automatically committed or rolled back as part of the transaction that fired them.
Using commit or rollback within a trigger can lead to unpredictable behavior and is not recommended.
- Q5. Materialized views and how to refresh
- Ans.
Materialized views store the results of a query and can be refreshed to update the data.
Materialized views store the results of a query in a table-like structure
They can be refreshed manually or automatically based on a schedule
Refresh options include full, fast, and force refresh
Example: CREATE MATERIALIZED VIEW mv_name AS SELECT * FROM table_name;
- Q6. Print 1 to 10 using sql
- Ans.
Use CONNECT BY LEVEL to print numbers from 1 to 10 in Oracle SQL
Use CONNECT BY LEVEL to generate rows from 1 to 10
Select the generated numbers in the query
- Q7. What is Context switching ? And about collection types ...
- Ans.
Context switching is the process of storing and restoring the state of a CPU so that multiple processes can share the same CPU.
Context switching allows the CPU to switch from one process to another, enabling multitasking.
In Oracle PLSQL, collection types are used to store multiple values in a single variable.
Examples of collection types in PLSQL include arrays, nested tables, and associative arrays.
- Q8. Tell me about Analytical functions you worked on ?
- Ans.
Analytical functions are used to perform calculations across a set of rows related to the current row.
Analytical functions are used to calculate aggregate values based on a group of rows.
They can be used to calculate running totals, moving averages, rank, percentiles, etc.
Examples include functions like ROW_NUMBER(), RANK(), DENSE_RANK(), LAG(), LEAD(), SUM() OVER(), AVG() OVER().
- Q9. What are Set operators ,which one keep duplicates among them
- Ans.
Set operators are used to combine the result sets of two or more SELECT statements. UNION ALL keeps duplicates.
Set operators include UNION, UNION ALL, INTERSECT, and MINUS
UNION ALL retains duplicate rows from the result sets
Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2
Interview Preparation Tips
- Siva academy
- Techtfq
- Kudvenkat
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. SQL full
What people are saying about Infosys
Interview questions from similar companies
I applied via Walk-in and was interviewed before Dec 2020. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Basic Programming questions.
- Q2. Fibonacci program
- Q3. OOPS concepts.
Interview Preparation Tips
I was interviewed in Mar 2021.
Interview Questionnaire
1 Question
- Q1. .net core , mvc basics and some scripting language
Interview Preparation Tips
I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. They totally asked me on Java and we have to be confident while answering them.
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jan 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Oops concepts, Exception Handling & other Core Java concepts
Interview Preparation Tips
Go to companies' websites & create ur profile.
Update ur profile daily on naukri. 👍🏻
I applied via Naukri.com and was interviewed in Mar 2021. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. Coding
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Mar 2021. There were 3 interview rounds.
(16 Questions)
- Q1. What are your salary expectations?
- Ans.
I am open to discussing salary based on the responsibilities and opportunities offered by the position.
I am flexible and open to negotiation.
I am looking for a competitive salary that reflects my skills and experience.
I am more interested in the overall compensation package, including benefits and growth opportunities.
I would like to learn more about the company's salary range for this position.
I am confident that we c
- Q2. What is your family background?
- Ans.
My family background is diverse and multicultural.
My parents are from different countries, which has exposed me to different cultures and perspectives.
I have relatives who work in various industries, including technology and healthcare.
Growing up, my family encouraged me to pursue my interests in computer science and supported my education in the field.
- Q3. Share details of your previous job.
- Ans.
I worked as a Software Developer at XYZ Company.
Developed and maintained software applications using Java and Python.
Collaborated with a team of developers to design and implement new features.
Participated in code reviews and debugging sessions to ensure high-quality code.
Worked closely with clients to gather requirements and provide technical support.
Implemented unit tests and performed software testing to identify an...
- Q4. Why should we hire you?
- Ans.
I have a strong background in software development and a proven track record of delivering high-quality projects on time and within budget.
I have a deep understanding of various programming languages and frameworks, allowing me to adapt quickly to new technologies.
I am highly skilled in problem-solving and troubleshooting, which enables me to identify and resolve issues efficiently.
I am a team player and have excellent...
- Q5. Why are you looking for a change?
- Ans.
Looking for new challenges and growth opportunities.
Seeking a more challenging role to enhance my skills and knowledge.
Interested in working on cutting-edge technologies and projects.
Want to be part of a dynamic and innovative team.
Desire to expand my professional network and learn from industry experts.
- Q6. Where do you see yourself in 5 years?
- Ans.
In 5 years, I see myself as a senior software developer leading a team and working on complex projects.
Leading a team of developers
Working on complex projects
Continuously learning and staying updated with new technologies
Contributing to the growth and success of the company
- Q7. What are your strengths and weaknesses?
- Ans.
My strengths include problem-solving, attention to detail, and teamwork. My weaknesses include time management and public speaking.
Strengths: problem-solving, attention to detail, teamwork
Weaknesses: time management, public speaking
- Q8. Tell me about yourself.
- Ans.
I am a software developer with experience in various programming languages and a passion for creating innovative solutions.
Experienced in Java, C++, and Python
Developed a mobile app using React Native
Worked on a team to create a web application using Angular
Strong problem-solving and analytical skills
- Q9. Tell me about yourself
- Ans.
I am a software developer with experience in web development and a passion for problem-solving.
Experienced in web development using HTML, CSS, and JavaScript
Proficient in programming languages such as Java and Python
Familiar with frameworks like React and Angular
Strong problem-solving and analytical skills
Excellent teamwork and communication abilities
- Q10. What are your strength and weakness
- Ans.
My strength is problem-solving and my weakness is sometimes overthinking.
Strength: Problem-solving
Weakness: Overthinking
- Q11. Where do you see yourself in 5 year's
- Ans.
In 5 years, I see myself as a senior software developer leading a team and working on complex projects.
Leading a team of developers
Working on complex projects
Continuously learning and improving my skills
Contributing to the growth and success of the company
- Q12. Why are you looking for a change
- Ans.
Seeking new opportunities for professional growth and challenges.
Looking for a more challenging role
Want to expand my skill set
Seeking better career prospects
Interested in working with new technologies
Want to work in a more collaborative environment
- Q13. I think I am very flexible and adaptive to learning new things
- Q14. Share your details for your previous job
- Ans.
I worked as a Software Developer at XYZ Company.
Developed and maintained web applications using Java and Spring framework
Collaborated with cross-functional teams to gather requirements and design solutions
Implemented unit tests and performed code reviews to ensure code quality
Participated in Agile development process and attended daily stand-up meetings
Troubleshooted and resolved software defects reported by users
- Q15. What is your family background
- Ans.
My family background is diverse and multicultural, with members from different professions and cultural backgrounds.
My father is a doctor and my mother is a teacher.
I have two siblings, one is an engineer and the other is a lawyer.
We celebrate various cultural festivals and traditions together.
My family values education and encourages continuous learning.
- Q16. What are your salary expectations
- Ans.
I am open to discussing salary based on the responsibilities and opportunities offered by the position.
I am flexible and open to negotiation.
I am looking for a fair and competitive salary based on my skills and experience.
I am more interested in the overall compensation package, including benefits and growth opportunities.
I am confident that we can come to a mutually beneficial agreement.
Interview Preparation Tips
I'm from Vinukonda
I'm ready to the interview
I applied via Naukri.com and was interviewed before Nov 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Related to job role
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. In C# --> Abstraction, Interface , Abstract Method, Abstract Class, Polymorphisms, Encapsulation ,Inheritance, Serialization,
- Ans.
C# concepts including abstraction, interface, abstract method, abstract class, polymorphism, encapsulation, inheritance, and serialization.
Abstraction: hiding implementation details
Interface: defining a contract for behavior
Abstract method: method without implementation
Abstract class: class with one or more abstract methods
Polymorphism: ability of objects to take on multiple forms
Encapsulation: bundling data and behavi...
Skills evaluated in this interview
Infosys Interview FAQs
Recently Viewed
DESIGNATION
DESIGNATION
SALARIES
GlobalLogic
INTERVIEWS
Infosys
No Interviews
DESIGNATION
DESIGNATION
INTERVIEWS
Infosys
No Interviews
INTERVIEWS
Infosys
No Interviews
DESIGNATION
INTERVIEWS
Infosys
No Interviews
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 Associate Consultant Interview Questions
- Infosys Senior Systems Engineer 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
Infosys Oracle SQL and PLSQL Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Infosys Oracle SQL and PLSQL Developer Reviews and Ratings
based on 1 review
Rating in categories
|
Technology Analyst
55.4k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Systems Engineer
50.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
System Engineer
39.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Technical Lead
30.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Associate Consultant
27.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Wipro
Cognizant
Accenture
- Home >
- Interviews >
- Infosys Interview Questions >
- Infosys Oracle SQL and PLSQL Developer Interview Questions
