Interview Questions

Q:

Which are the main MIS Reports of an accounts department & what the format of preparing the MIS ?

Answer

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..

Report Error

View answer Workspace Report Error Discuss

3 9938
Q:

What is Demat Account ?

Answer

The way in which a bank keeps money in a deposit account in the same way the Depository company converts share certificates into electronic form and keep them in a Demat account.


 

Report Error

View answer Workspace Report Error Discuss

17 9807
Q:

How do you put a message in the browser's status bar ?

A) status("put your message here") B) window.status = "put your message here"
C) statusbar = "put your message here" D) window.status("put your message here")
 
Answer & Explanation Answer: B) window.status = "put your message here"

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: Web Technology - Technology

3 9800
Q:

Write an SQL Query find number of employees according to gender whose DOB is between 01/01/1960 to 31/12/1975.

Answer

SELECT COUNT(*), sex from Employees  WHERE  DOB BETWEEN ‘01/01/1960 ' AND ‘31/12/1975’  GROUP BY sex;

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

10 9452
Q:

Write an SQL Query to check whether date passed to Query is date of given format or not.

Answer

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.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

7 9366
Q:

What is the full form of the trem WIRE in wire payment ? Explain the process for making and receiving the payment through WIRE?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

15 9287
Q:

In tree construction which is the suitable efficient data structure?

A) Array B) Linked list
C) Stack D) Queue
 
Answer & Explanation Answer: B) Linked list

Explanation:

Linked list is the efficient datastructure in tree construction

Report Error

View Answer Workspace Report Error Discuss

Filed Under: C++ - Technology

2 9177
Q:

What is the difference between agglomerative and divisive Hierarchical Clustering?

Answer

- Agglomerative Hierarchical clustering method allows the clusters to be read from bottom to top and it follows this approach so that the program always reads from the sub-component first then moves to the parent. Whereas, divisive uses top-bottom approach in which the parent is visited first then the child. 


- Agglomerative hierarchical method consists of objects in which each object creates its own clusters and these clusters are grouped together to create a large cluster. It defines a process of merging that carries on till all the single clusters are merged together into a complete big cluster that will consists of all the objects of child clusters. Whereas, in divisive the parent cluster is divided into smaller cluster and it keeps on dividing till each cluster has a single object to represent.

Report Error

View answer Workspace Report Error Discuss

3 8937