Chapter – 7
pL/SQL teChniCaL
interview tipS
& preparation
Let’s make coding fun!
SampLe pL/SQL teChniCaL interview QueStion
• Difference between SQL and PL/SQL and why do we need
PL/SQL?
PL Sql vs Sql
Comparison SQL PL/SQL
Single command at
Execution Block of code
a time
Source of data to be Application created by
Application
displayed data aquired by SQL
DDL and DML
Includes procedures,
Structures include based queries and
functions, etc
commands
Creating applications to
Recommended Performing CRUD
display data obtained
while operations on data
using sql
SQL can be
Compatibility with PL/SQL cant be
embedded into
each other embedded in SQL
PL/SQL
• Difference between %TYPE and %ROWTYPE
• Difference between in execution of Triggers and Procedures
• Differentiate between syntax and runtime errors?
• Difference between in execution of Triggers and Constraints
and INSTEAD OF Trigger?
• What are the 3 modes of parameters?
• Why is %ISOPEN always false for an implicit cursor?
• What do you understand by Exception handling in PL/SQL?
List the predefined exception?
• Difference between cursor declared in procedures and cursors
declared in the package specification?
• What do you understand by PL/SQL Records?
• Write a PL/SQL script to display the following series of
numbers: 99,96,93……9,6,3?
• Bubble Sort or Odd Even Sort or any well-known algorithm to
implement
SampLe non teChniCaL interview QueStionS
Tell me about yourself?
• How will you rate yourself for PL/SQL ?
• What do you like to do outside of work?
• How would your boss and co-workers describe you?
• How do you deal with pressure or stressful situations?
• Brainteaser question: How many tennis balls can you fit into
a limousine?
• Do you have any questions for us? What are your salary
requirements? Learn about Employer
important FaCtS
• PL/SQL code outside the package reference objects from
within the package using dot notation, declared in package
specification called PUBLIC
• Objects that are declared inside the package body, their use is
restricted to within that package only called PRIVATE
• Multiple procedures that are declared with the same name are
called Overloaded Procedures.
• Multiple functions that are declared with the same name are
called Overloaded Functions
ConCLuSion
In this chapter, we have shared some sample PL/SQL technical
interview question and information about OCP PL/SQL developer
certification.