Last week I wrote what need to put in resume with respect to their experience
This post only who are applying as sql/plsql developer
First
we have to know Oracle is database .there may be different application
to retrieve this data from the frontend (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 is this domain?
Domain 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*
0 comments :
Post a Comment