Interview Questions

Q:

What is Marshalling?

Answer

Marshalling is the process of gathering data from one or more applications or non-contiguous sources in computer storage, putting the data pieces into a message buffer, and organizing or converting the data into a format that is prescribed for a particular receiver or programming interface.  

Report Error

View answer Workspace Report Error Discuss

0 2690
Q:

What is the Routing Information Protocol or RIP?

Answer

RIP is a is an interior gateway protocol that was often used in interior networks and in some degree in internet networks. It helps the router adapt to the modifications that are made in a network regarding connections. Now it become less used since more efficient protocols were implemented like OSPF or IS-IS. It is limited to a lower number of routers, a maximum of fifteen router.

Report Error

View answer Workspace Report Error Discuss

0 2688
Q:

How will you find the 3rd max salary in the employment table?

Answer

SELECT DISTINCT(salary) FROM emp as e1 


WHERE (3) = (SELECT COUNT(DISTINCT(salary)) FROM emp as e2  WHERE e1.salary <= e2.salary)

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 2687
Q:

what is the job description of a payroll officer?

Answer

1. Collection of attendance / collation of attendance


2. Scrutunizing the received attendance 


3. Calculating the salary as per the attendance, based on LOP received


4. Once the Payroll Processing is over, the gross salary should be checked with Master Data of salary.


5. Netpay has to request for bank transfers / cheque 


6. Need to take care of statutories like PF / ESI / PT / Income Tax


7. While processing salary, statutory deductions like PF / ESIC / PT and income tax calculations tobe taken care.


8. Arriving the salary structure for New Joiners


9. F&F tobe done for resigned employees


10. PF & ESI Nomination has to take care for the new joiners


11. PF Settlement / PF transfer has to take care for the resigned employees after 60days from the date of resignation.

Report Error

View answer Workspace Report Error Discuss

2 2687
Q:

How can we call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL?

Answer

EXECUTE IMMEDIATE command can be used to call DDL statements. 


Example:


BEGIN


EXECUTE IMMEDIATE  'TRUNCATE TABLE employee';


END;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2686
Q:

What are the differences between static ip addressing and dynamic ip addressing?

Answer

With static IP addressing, a computer (or other device) is configured to always use the same IP address. With dynamic addressing, the IP address can change periodically and is managed by a centralized network service

Report Error

View answer Workspace Report Error Discuss

0 2685
Q:

How can you send an email message from an ASP.NET Web page?

Answer

You can use the System.Net.Mail.MailMessage and the System.Net.Mail.SmtpMail classes to send an email in your Web pages. In order to send an email through your mail server, you need to create an object of the SmtpClient class and set the server name, port, and credentials.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2684
Q:

Assets minus liabilities equals

A) Equity B) Net income
C) Working capital D) Net assets
 
Answer & Explanation Answer: A) Equity

Explanation:

Assets minus liabilities equals Equity.

assets_minus_liabilities_equals1556624662.png image

Report Error

View Answer Report Error Discuss

Filed Under: Accounts Receivable
Exam Prep: CAT , Bank Exams , AIEEE
Job Role: Bank PO , Bank Clerk , Analyst

6 2683