Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What kind of pl sql questions to expect for a client technical interview

610795Nov 22 2009 — edited Nov 25 2009
Please advise all the experienced professionals

What kind of questions should i expect in the client facing technical interview i am having for a PL SQL Developer with Performance Tuning interview. The Client project is mostly a Financial Project.

Yes of course i would be asked basically tell me about the projects that you been involved in based on which they ask the questions, basically i am not highly experienced 3 years and my experience involves limited performance tuning, developing scripts for supporting front end web applications.

What kind of questions( you dont need to list out the questions specifically, it would be helpful if you could advise the areas which i should look into, also any links where i can read regarding the area you suggest when facing a client interview).
Example: Financial Transactions would deal a lot with Trasaction Processing so i should prepare for questions on Mutating Table, deadlocking.
Also i am aware of Collections,External Tables. Would these be discussed.

Any advise would be very much helpful.
My experience does not heavily involve any financial experience and the job specification didnt state so i got through the first 2 interview rounds. Would it be a disadvantage if i said i held no finanicial experience, i am just assuming by hearing from some sources that the client is finance area.
I would be recruited only if the client approves, so i need to look into as much as possible, there is time to prepare so kindly advise.

Regards.
This post has been answered by Billy Verreynne on Nov 23 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 23 2009
Added on Nov 22 2009
6 comments
2,374 views