CoverPhoto
Infosys logo
Premium Employer

Infosys

Verified
3.6
based on 39.5k Reviews
Filter interviews by
Oracle SQL and PLSQL Developer
Fresher
Clear (1)

Infosys Oracle SQL and PLSQL Developer Interview Questions and Answers

Updated 11 Nov 2024

Q1. 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().

Add your answer
right arrow

Q2. 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.

Add your answer
right arrow
Infosys Oracle SQL and PLSQL Developer Interview Questions and Answers for Freshers
illustration image

Q3. 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

Add your answer
right arrow

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.

Add your answer
right arrow
Discover Infosys interview dos and don'ts from real experiences

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;

Add your answer
right arrow

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

Add your answer
right arrow
Contribute & help others!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos

Interview Process at Infosys Oracle SQL and PLSQL Developer

based on 1 interviews
Interview experience
2.0
Poor
View more
interview tips and stories logo
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories
Recently Viewed
INTERVIEWS
Infosys
600 top interview questions
INTERVIEWS
Siemens
10 top interview questions
INTERVIEWS
Infosys
90 top interview questions
INTERVIEWS
LTIMindtree
10 top interview questions
SALARIES
Publicis Sapient
INTERVIEWS
Infosys
No Interviews
INTERVIEWS
Infosys
10 top interview questions
DESIGNATION
SALARIES
HCL Infosystems
INTERVIEWS
Uplers
10 top interview questions
Share an Interview
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter