Total Pageviews

February 18, 2015

2/18/2015 06:47:00 AM
Last week I wrote what need to write  in resume with respect to their experience

I am going to discuss about sql-developer job related resume content.What you can expect in the interview



First we have to know Oracle is database .there may be different application to retrieve this data from the front-end (it may be asp.net,sap or third party application)
First need to tell what type project you involved .Here domain comes into picture.
What meant by domain?
Domain(Verticle)  may be Education, Manufacturing, aviation, banking, shipping, Entertainment, Telecommunication etc.
In your resume you have mention for which domain you developed the application
While applying for the sql developer post
You have to know the architecture of the database; you have to know

  • What is normalization?, 
  • what are the  new features in the latest version.
  • What are the advantages if you are using these features
  • We have mainly DDL (Data Definition Language) DDL (Data definition language), triggers, sequences,
  •  Indexes, 
  •  Error handling,
  •  Packages
Suppose if the applicant used triggers in his/her project he/she needs to know why he/she wrote the trigger. In which scenario he/she wrote the trigger.
if you have to familiar with these type of question when he/she facing interview
if I ask this question
DECLARE
   l_empno   NUMBER := 100;
BEGIN
   l_empno := 200;
   DBMS_OUTPUT.put_line ('Value of l_empno' || l_empno);
END;
Employer/interviewer expects the concepts of local variable and propagation in the block.
In many cases in the table for columns don’t have values in this case you have to know the concept of nvl.nvl2,
Empno
Ename
Sal
Comm.
Gross salary
10
Xyz
10000

10000
20
Abc
2000
20
2020
30
Wxy
3000

3000

for the above scenario applicant needs to know how to handle null values, the concept of nvl comes here.
I will keep post some other scenarios tomorrow
Keep reading

*Read*Explore*Succeed*