Stored procedures are nothing but named blocks which contains the group of SQL statements to achieve specific functionality.A stored procedure or in simple a proc is a named PL/SQL block which performs one or more specific task. This is similar to a procedure in other programming languages.Stored Procedures accepts the different input parameters and gives the result as per requirement of user. PL/SQL is executed in the database, you can include SQL statements in your code without having to establish a separate connection.Stored Procedure reduces the network traffic and improves the system performance.Stored procedures are used to ensure the data integrity of database.

There were 2 interviewers. I was asked multiple basic questions on Oracle SQL and PL/SQL as well as scenario-based questions moreover questions on my past experience based on the resume.