PL/SQL as a procedural extension language from oracle for classical SQL is one of the relatively recently born programming languages. Together with Java and SQL it is one of the three key programming languages in Oracle Database.
PL/SQL interview questions test mainly your practical knowledge of language and databases. We collected a list of commonly used questions to help you with your practice prior to the job interview. Try to answer as many questions as you can!
- Does PL/SQL support Arrays?
- Can PL/SQL code containers be compiled into any Oracle Database? If yes, describe the process behind the scenes.
- What are user defined exceptions in PL/SQL?
- Define predefined exceptions in PL/SQL. Who predefined these exceptions? Can you write a code of such an exception?
- Define three main parameters isud in PL/SQL
- What can contain date variable in PL/SQL and what about character variable? Can you write examples of both?
- Define looping and give an example of code in PL/SQL. Speaking about real database, let’s say SQL database of this website. How could be looping used to bring any advantages to the users of the site?
As you can see, if you do not posses a strong knowledge of PL/SQL, your chances of making any impression in the job interview are negligible. PL/SQL job interview questions will test you really deeply, and you should not only talk but also be able to demonstrate something in practice. Anyway, have a look at some more questions.
- How does implicit cursor work?
- What is the difference between implicit and explicit cursor?
- How can you handle various table errors in PL/SQL? Give some concrete examples of table errors you have come to during your PL/SQL experience and say how did you handle each of them.
- Is there any way to generate debugging output from PL/SQL?
This is a list of some commonly used PL/SQL interview questions. If you are not sure about the answers, you should rather polish your PL/SQL training books, or simply sit at the computer and work with databases for couple of hours.
Sometimes that’s the best practice for PL/SQL interview. Do not forget that in the interviews, luck favors the prepared.