Interview Questions

Amazon SQS is a message passing mechanism that is used for communication between different connectors that are connected with each other. It also acts as a communicator between various components of Amazon. It keeps all the different functional components together. This functionality helps different components to be loosely coupled, and provide an architecture that is more failure resilient system.

PL/SQL is Procedural Language SQL that is an extension of SQL that results in a more structural language composed of blocks. It is mainly used in writing applications that needs to be structured and has error handling.

The ServiceInstaller class, also known as the project installer class, is used to install a Windows service.

XML templates are XML files such as XHTML files. XML templates includes the processing directives which affect how the template is rendered, and the template expressions which are substituted dynamically by various data.

What are your strengths?

Purpose - The question is asked by the interviewer to understand your key selling point and get to know if it is relevant and helpful to handle the responsibilities that the person will handle if hired.

Note - All Most all Interviewers/Hiring people in management who assign tasks and responsibilities feel that a person is productive in work if his strength matches to the responsibilities of the role. So expect this question in most interviews. Also, be aware Strengths give clues on your interest.

Approach - Pick 2 or 3 strengths and give examples for each 1 to demonstrate how you used it in the previous job or in life. You can identify Some of your strengths from below list.
Continuous learning
Problem solving
Multi-tasking
Self learning
Flexible
Team Player
Hard working
Like Challenges
Quick Learner
Self Motivated
Communication, Oral and Written
Process Oriented
Analytical

Pre-work -Understand the job requirement in detail and get to know in advance what are the responsibilities the role you are applying and accordingly pick your strength that is relevant to the role. It would be advantageous to know the problems are issues the company is facing and what was the reason for the opening. You should be prepared for this question. It is one of the most commonly asked interview question.

E.g.: Communication and presentation - Communication and presentation is my strength.
In my previous job, I was given additional responsibilities to present and facilitate project status meetings with executive management and team building activities across departments.

This question is designed to see how well you can mediate a situation and handle conflict. You want to come across as someone who can compromise when necessary. An interviewer wants to see that you can not only reach an outcome that is desirable for both sides of a conflict of interest, but also that you can understand where the other person is coming from. Empathy and understanding go a long way in any job and this is a good opportunity to show that you can put yourself in another’s shoes.

COMMIT statements are used to release locks which are required for that unit of work, and then permit a new unit of work. In other words, if COMMITS are not coded in the program and the program has been sent for execution, then while processing, in place of just going back to a few inserts since the nearest commit, the program has to go back to the inserts which were made during the entire run of the program. This extra process takes around twice or thrice the time taken normally.