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*
