Pl SQL Developer Interview Questions | Glassdoor

Pl SQL Developer Interview Questions


Pl sql developer interview questions shared by candidates

Top Interview Questions

Sort: RelevancePopular Date

What is the ascii code for line feed?

1 Answer

CHR(10) is the answer but this is such a waste of time to ask. This doesn't indicate that you can code or can think through tough assignments to come up with a reasonable solution.

Tell us why you’re interested in the company and why you think you’d be a good fit for the role.

When would you use dynamic sql?

1 Answer

Write a schema for a pet shop with different animals and different store locations.

1 Answer

Not unexpectedly, the manager was particularly interested in my experience in gathering requirements and creating designs.

3 Answers

interview faqs are very common ones. Just google for plsql developer interview questions.

Packages, cursors, pipeline functions, indexes, SQL tunning

IF I would be interested in working as an Oracle DB Admin

1 Answer

They asked me to write an Oracle procedure that would select data from 3 tables and update a 4th table. (handwritten, not in Oracle) This was to be completed in 15 minutes.

1 Answer

the test question can be tricky and don't make it too complicated

110 of 10 Interview Questions