Category: 

What are Common PL-SQL Interview Questions?

Article Details
  • Written By: J. Boland
  • Edited By: A. Joseph
  • Last Modified Date: 21 July 2018
  • Copyright Protected:
    2003-2018
    Conjecture Corporation
  • Print this Article
Free Widgets for your Site/Blog
Former LA Lakers star Kobe Bryant was the first NBA player to win an Oscar, for the short film “Dear Basketball."  more...

August 16 ,  1987 :  An airliner crashed onto a highway in Detroit; the only survivor was one 4-year-old passenger.  more...

The most common Procedural Language-Structured Query Language (PL-SQL) interview questions are designed to reveal the depth of knowledge that the candidate has about the subject. For this reason, the opening questions are typically broad in scope and relate to subjects such as the differences between the industry standard American National Standards Institute (ANSI) SQL and PL-SQL. Likewise, a candidate might be asked to discuss the advantages and disadvantages of using stored procedures rather than a client-side solution. Further questions drill down to the specifics of the language.

There are some fundamental concepts that will almost always appear in PL-SQL interview questions. Some examples are: What is a procedure? What is a package? How and when should you implement triggers? How do you handle exceptions in PL-SQL? Anybody who has been working with PL-SQL, even at a basic level, should be very familiar with these concepts.

More direct and specific PL-SQL interview questions attempt to reveal a deeper knowledge and experience with common issues that face the PL-SQL developer. How do you handle NULL values? What is the difference between a NULL value and a value of zero? What are the most common data types used in PL-SQL? What is a BLOB? When is it appropriate to use a type of varchar? The handling of data types is critical to the integrity of data and the overall performance of a system, so these subjects will be foremost in the mind of a manager.

Ad

Another favorite topic for PL-SQL interview questions is cursors. The use of cursors in PL-SQL is fundamental to all data retrieval and manipulation, so many PL-SQL interview questions are centered around this subject. Some typical questions that might be encountered are: What keyword identifies the column-type of a cursor field? How do you handle a situation where a SELECT cursor returns no data? How often should you perform a commit when you are inserting records? What issues might you face regarding concurrent access on a table? What is a deadlock and what is the most efficient manner in which it can be resolved?

PL-SQL is a very rich programming language, so it is rare that somebody will know every single detail. Some of these common interview questions can reveal the knowledge and experience that a candidate has acquired. The broad discussion-type questions are a real opportunity for a candidate to exhibit mastery of the features and complexity of PL-SQL.

Ad

You might also Like

Recommended

Discuss this Article

anon1000167
Post 2

So bloody thorough! Ah! So happy and blissed out! I feel redeemed by reading the topic. Keep up the good work!

to some of you this question is simple to answer. For me it took some time of watching youtube, learning in internet and still got no answer to this.

Lets say I have data in Table_X:

And I want to get this from my excel query:

My query is this:

SELECT

Client_id,

SUM ( CASE WHEN (Voucher type = 'M20')

THEN Amount

ELSE 0

END) AS "Amount M20",

SUM ( CASE WHEN (Voucher type = 'IP4')

THEN Amount

ELSE 0

END) AS "Amount IP4",

Activity

FROM TABLE_X

WHERE Activity IS NOT NULL

And Output is missing IP4 calculation, because of Where condition:

But if I remove Where condition, then I get doubling of rows and this is far away from my desired output.

Thank you! This saved my butt today, and I’m immensely grateful.

Thank you,

Preethi.

Post your comments

Post Anonymously

Login

username
password
forgot password?

Register

username
password
confirm
email