RBN-INFO-TECH : Interview Tips

Q: What job would you like to have in five years time?

It's a mistake if you haven't thought about this question and how to answer it. Your interviewer will use your response to gauge your desired career direction, your ability to plan out how to achieve your goal and what moves you are making to reach it. It will also tell them how real your desire to reach your goal is and to what extent their organisation can accommodate your aspirations. A good answer will include the following: an acknowledgement from you that you have things to learn; that you would like the company to help you with this learning; and that although you have progression within this department in your sights you will also consider other opportunities throughout the company, should they arise.

Q: Why do you want to work here..?

This requires some forethought. It means that you go into an interview forearmed with facts and information about the company you are looking for a job with. If you've done your homework you have nothing to fear. Your reply should include the company's attributes as you see them and why these attributes will bring out the best in you.

Q: How do you work under pressure?

This question is offering you the opportunity to sell your skills to your prospective employer. Think of an example in your current job, explain how it arose and how you dealt with it. Do not say anything negative about yourself unless you can finish off your reply with what you have learned from the experience. You can also use this question to demonstrate how you can alleviate pressured work situations arising - that your own capabilities to plan and manage your time can reduce hasty decisions and panicked deadlines arising.

Q: Why do you want to leave your current job..?

The acceptable answers to this question fall into two categories, how you feel about your career and how you feel about the company you currently work for. And your answer may include a combination of reasons from both areas. Regarding your career - do you want fresh challenges? More opportunity for growth? Would you like to develop new skills? With regard to the company, did you feel that your position was not secure? Was there nowhere else for you to go in the department? Does the company you are applying for a job with have a better reputation?

Q: What specifically do you have to offer us?

Start your answer with a recap of the job description of the post you are applying for, then meet it point by point with your skills. It's important that you also paint a picture of yourself as a problem solver, someone who can take direction and who is a team player, and of course someone who is not only interested in their personal career success, but the success of the company.

Q: What is your greatest weakness..?

This question is an attempt by the interviewer to tempt you into casting yourself in a negative light - don't do it. Always turn your weaknesses into positives, and keep your answer general. Try to think about allowable weaknesses for example , a lack of knowledge in a certain area is an opportunity for development. Frustration with others may signal your total commitment to a project or a perfectionist nature.

Q: What are your greatest accomplishments..?

Keep your answer to this question job related, think of past projects or initiatives which you have played a part in and which have brought positive results for you and the company. Do not exaggerate your role, if your greatest achievement occurred as part of a team, then say so. It not only shows your ability to work with others, but to share credit when credit is due.

Q: How do you handle criticism..?

This question is designed to find out if you are manageable as an employee. In your answer you must present yourself as someone who will accept direction, but who also has a decent quotient of self-respect. Everyone deserves a reason and explanation for criticism. If your manager does this in a way which respects your situation then you should say that this is acceptable to you and that you will grow from it. If the correction is brusque, you should also say that you can accept this too - your boss may have something on his/her mind, you must show yourself as someone who can recognise the bigger picture.

Q: Are you willing to travel/relocate?

In this question you may find yourself caught between a rock and a hard place. If you say no - you might as well end the interview there and then. If you say yes, who is to say you won't end up in Alaska? Find out what they are really asking - is it business travel or is the company relocating? If relocation is the option there are two ways to play this - be honest, or veer towards yes whatever, after all your goal at interview is to get a job offer, without such an offer you have no decision to make, and no chips to bargain with.

Q: What kind of people do you like working with?

A: Easy, people like you! In this question you can again flag up your attributes as attributes you expect in others. Key words are pride, dedication, self-respect and honesty.

RBN-INFO-TECH

RBN-INFO-TECH : Merge Satement In Oracle

Oracle introduces the new MERGE SQL command. The much more elegant way to insert or update data with Plsql is to use Oracles merge command.It is a DML command that enables us to optionally update or insert data into a target table, depending on whether matching already existing records. In oracle 9i, we would have to code this scenario either in separate bulk SQL statements or in PL/SQL. We will compare MERGE to these methods later in this article.

Syntax

Merge into destination_table X using source_table Y  on (X.unique_id = Y.unique_id)  when matched then    Update  set X.name = Y.name,      X.rollno = Y.rollno,      X.address = Y.address  when not matched then  insert (X.contact_id,     X.date_of_birth,     X.full_name,     X.unique_id)  values ('16-mar-1988',     Y.DoB,     Y.full_name,     Y.unique_id);

Example-:

We can now see an example of the MERGE statement. In the following example, we will merge the source table into the target table. We  will  capture a count of the target table rows before and after the merge.
SQL> SELECT COUNT(*) FROM target_table;
    COUNT(*) ----------      43485  1 row selected. 
 SQL> MERGE   2     INTO  target_table tgt   3     USING source_table src   4  
   ON  ( src.object_id = tgt.object_id )   
5  WHEN MATCHED   6  THEN   7     UPDATE   8    
 SET   tgt.object_name = src.object_name   9     ,     tgt.object_type = src.object_type  10  WHEN NOT MATCHED  11  THEN  12  
   INSERT ( tgt.object_id  13            , tgt.object_name  14            , tgt.object_type )  
15     VALUES ( src.object_id  16            , src.object_name  17            , src.object_type );
  95865 rows merged.
Note the following clauses -:
MERGE (line 1)   : as stated previously, this is now the 4th DML statement in Oracle. Any hints we might wish to add directly follow this keyword (i.e. MERGE /*+ HINT */);
INTO (line 2)      : this is how we specify the target for the MERGE. The target must be either a table or an updateable view (an in-line view cannot be used here);
USING (line 3)   : the USING clause represents the source dataset for the MERGE. This can be a single table (as in our example) or an in-line view;
ON () (line 4)    : the ON clause is where we supply the join between the source dataset and target table. Note that the join conditions must be in parentheses;
WHEN MATCHED (line 5) : this clause is where we instruct Oracle on what to do when we already have a matching record in the target table (i.e. there is a join between the source and target datasets). We obviously want an UPDATE in this case. One of the restrictions of this clause is that we cannot update any of the columns used in the ON clause (though of course we don't need to as they already match). Any attempt to include a join column will raise an unintuitive invalid identifier exception .  and
WHEN NOT MATCHED (line 10) : this clause is where we INSERT records for which there is no current match.
Note that sqlplus reports the number of rows merged. This includes both the updates and inserts. Oracle treats MERGE as a MERGE and not an UPDATE+INSERT statement. The same is true of SQL%ROWCOUNT in PL/SQL.
RBN-INFO-TECH