Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Aug 18, 2010

Top 9 Database Object Tips You Need to Know for Your Next PLSQL Job Interview

By James Koopmann

Interviewing for a PL/SQL developer position ultimately will turn towards talking about database structures and objects. This article goes beyond the basic table and index questions that you might expect and offers a tip or two designed to impress the interviewer.

Interviewing for a PL/SQL developer position ultimately will turn towards talking about database structures and objects. But most of us will begin to fall asleep if we have to answer some of the more basic questions about what a table is, what a column is, what an index is, etc. Moreover, I don't want to bore you with having to read through the more basic questions and answers. Instead, I thought it would be much more beneficial if I took from my experiences as a DBA / Developer those pieces of information I actually used and thought could help you spice up your studying for that next job interview.

Again, as you read these, especially if you're getting ready for an interview, remember that these questions are not hard and fast, many of them beg for further investigation and many of them you should try within your own sandbox if you've not ever encountered them before. Good luck. I hope these questions get you started down the right path.

1. Define "Normal Form" and give brief descriptions of the levels

Most shops want everyone to at least understand that there is some order in the universe and that "Normal Form" is what controls this within our databases. For most purposes this is correct so do brush up on what "Normal Form" is by reviewing these very basic definitions; realizing that there is more to each definition and there are higher levels then third normal form but this will be plenty for most interviews.

Normal Form - is nothing more than a set of criteria within relational database theory that aids in determining a table's degree of vulnerability against logical inconsistencies and anomalies.

First Normal Form - No repeating elements or groups of elements

Second Normal Form - No partial dependencies on the primary key

Third Normal Form - No dependencies on non-key attributes

View article

» See All Articles by Columnist James Koopmann

Oracle Archives

Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM