Interview Questions

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 2745
Q:

What is PO invoice ?

Answer

For material/Goods Purchases, the Po is required. In the Po, QTY, Product Name, Where is delivery price, Terms and Conditions. In the po there is no matter of final amount. It is just the approximate amount.

Report Error

View answer Workspace Report Error Discuss

Subject: Accounts Payable Exam Prep: Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

1 2743
Q:

What is a Session?

Answer

A session is a logical object created by the PHP engine to allow you to preserve data across subsequent HTTP requests. Sessions are commonly used to store temporary data to allow multiple PHP pages to offer a complete functional transaction for the same visitor.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2743
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 2740
Q:

What are user defined data-types and when do you use them?

Answer

User defined data-types in SQL is an extension to the base SQL server data-types by provision of a descriptive name.


We use them to format the database and segregate specific repetitions of rows and columns in the database.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 2737
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 2737
Q:

What are different ABAP/4 editors? What are the differences?

Answer

The 2 editors are se38 and se80 both have the abap editor in place. In se38 you can go create programs and view online reports and basically do all thedevelopmet of objects in this editor. In se80 ( object navigator) there are additional features such as creating packages,module pool , function group ,classes, programs ( where you can create ur programs) and BSP applications .

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

0 2735
Q:

Describe account receivable?

Answer

Accounts Receivable means the amount which comes in to the business. Eg: If the trader made sales to the customer then obviously the trader will received the amount for the sales made. So here the amount which comes in is said to be accouts receivable.

Report Error

View answer Workspace Report Error Discuss

1 2734