Interview Questions

The Debit balance recovery is usually made by raising a credit memo for the regular vendors. However if there are no future transactions from the supplier, we ask the vendor to send the check / make an EFT for the amount due from him.

When payment is made to the wrong vendor or payment made in excess, in that case overpayment has gone to the vendor, So for us it is vendor debit balance.

For debit balance recovery, we can either follow-up with the vendor to send us the excess amount / refund back, or we can adjust that extra amount in future invoices submitted by that vendor

In Case no future transactions, we have to follow-up with the vendor, falling whicch we have to write off this amount.

MIS report is known as Management Information System... regarding the Manpower status of a particular month, place and overall..

It helps the Management in decision making.. like what are the reasons of resignation.. in which area attrition is high.. and so many things to help in decision making.. with the help of MIS you may prepare a lot of reports.. Like annual attrition.. region wise attrition.. region wise manpower.. graphical representation of regions manpower status.. and so on..

You may prepare the same at your end.As it will help you to prepare other such formats too.

I am describing you the contents with sheet wise..

First Sheet - Details of employee

a. E.Code

b. Name of employee

c. Date of birth          

d. Designation

e. CTC

f. Address for communication

g.Permanent address

h. Contact number

i. Blood group

j. Maximum qualification

k. Extra qualification

l.Total Experience

Second Sheet- Salary structure

In this sheet write down the complete salary structure.. and make a column what is salary after any revision

Third Sheet - New Joinees

In this sheet write down the name of New joinees of that month with detail like CTC,  Designation, DOB etc. 

Forth Sheet - Resigned employees

In this sheet write the name of employees who resigned during that particular month with details like name, designation, date of joining, Date of resignation, last working day.

Fifth sheet - Attrition rate

Based on this MIS report, you may find out the attrition report, Qualification analysis reports, team management reports and so on can prepare a number of reports..

There is no specific abbreviation for the term WIRE because when the payment is being made using this option, you will not see the physical movement of funds. It is all electronic. It is just like a current passes through Wire. 

Therefore Electronic movement of funds is campared with WIRE.

SQL has IsDate() function which is used to check passed value is date or not of specified format ,it returns 1(true) or 0(false) accordingly.

SELECT  ISDATE('1/08/13') AS "MM/DD/YY";

It will return 0 because passed date is not in correct format.

Tell us about a time when you missed a deadline.

(or)

Let's discuss a time when you missed a significant deadline.

If you answer something like "You never missed a deadline". Most interviewers will immediately conclude you are not experienced and may also feel you are lying. 

Approach - It is absolutely necessary to accept that you have missed a deadline and give reasons how you resolved and what you learned from it. This will demonstrate your experience.

You could say in one of the first projects earlier in your career you missed an important deadline and made the boss very upset. It was a great learning experience and after doing some introspection, you realized, you could have done better planning, prioritization and communication. Now, you use special tools, processes and methods to address these issues. Now your team, colleagues and management are always up to date so no surprises arise on meeting deadlines. 

Below are few things you may emphasize on in your response...

Effective planning

Procedural Improvements

Better Prioritization

Open communication

Better Status reporting

When amount of memory to be allocated is known beforehand i.e. at the the time of compilation, it is known as Static Memory Allocation. Once the memory is allocated statically, it cannot be deallocated during program run. So it leads to wastage of storage space.

Example:

int A[100];

When amount of memory to be allocated is not known beforehand, rather it is determined at the time of program run, it is called Dynamic Memory Allocation. It leads to efficient utilization of storage space.

Example:

cout << " Enter number of elements: ";

cin >> N;

int *A = new int[N]; // dynamic memory allocation

The comparison operator that is used in SQL is '='. Comparison operators test whether two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.