Oracle Developer Interview Questions
439
Oracle Developer interview questions shared by candidates
How to develop matrix report in oracle ?
2 Answers
What is the tnsnames?
2 Answers↳
it is a folder that contain database connection informations.
↳
It is a file that contains a database connections information
You think you may be overqualified for the position?
2 Answers↳
If you think I'm overqualified, don't waste both our time by calling me for an interview. Less
↳
it shows that company like you, try to answer in a positive way: “I know it’s important to follow direction at times and just run with it at times. I have developed the judgment through my experience to know which action is appropriate at which times.” Less
How to print first Sunday of a Month?
2 Answers↳
SELECT next_day(TRUNC(SYSDATE,'mm')-1,'sun') FROM dual
↳
select next_day( date,'SUNDAY' ) from dual;
about database generally - about forms and reports - about procedures, functions, and trigger
1 Answers↳
prepared by reading about database design - read about triggers tricks
They asked about my job profile in my previous organization
1 Answers↳
I stated the roles that I have played in my previous organization
Interrupting me while explain my resume: - Do you know what is this job about? because your profile make no sense. Afther that, second sentence said by IT representative: - I will be very sincere with you, I think you are still too junior for this position. - Do you know Java? (my resume of course don't say that so of course I don't know, and position is about Oracle tools) - So you really never took requisites from clients? (after explain I took requisites even tho I had team leaders that took general requisites first) - So you really don't have developed much (after explain I developed full user screens in Oracle tools) - So you only know Pl/SQL? because of course R is only for this statistical issues, not data management.
1 Answers↳
Of couse I said "yes, I did".
your recent project? Can you work on W2 with Walk waters, per hour 25 dollars?
1 Answers↳
not interested.