Interview Questions

Separation of an employee exists when the service of an employee comes to an end because of one reason or other. "Separation of employment" refers broadly to the process of managing the termination of employment. It is a sensitive issue for any organization. 

Types of separation:

1) Volunntary:

a) Resignation
b) Job abandonment
c) Retirement

2) Involuntary:

a) Layoff
b) Dismissal
c) Plant closure
d) Death or Disability.

The flow chart gives a clear graphical representation of an implemented process. This makes the system simple to understand for all persons involved in the project. 

As a wholesaler, applicant should say that he/she would face production problem, growing consumption, not concentrating on important market segment, scale of operations not being proper, delivery to different stores and having some issues with suppliers and not a good relationship with suppliers. I would face these problems in reaching the target commitment to suppliers as a wholesaler.

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.

SimpleTimeZone is a concrete subclass of TimeZone class. The TimeZone class represents a time zone, that is to be used with Gregorian calendar.

The SimpleTimeZone is created by using the base time zone offset from GMT time zone ID and rules, for starting and ending the time of daylight.

By default, primary key creates a clustered index on the column, whereas a unique key creates a non clustered index by default.