Interview Questions

SELECT DISTINCT(salary) FROM emp as e1 

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

MIME - Multi-purpose Internet Mail Extensions. 

MIME types represents a standard way of classifying file types over Internet. 

Web servers and browsers have a list of MIME types, which facilitates files transfer of the same type in the same way, irrespective of operating system they are working in.

A MIME type has two parts: a type and a subtype. They are separated by a slash (/). 

MIME type for Microsoft Word files is application and the subtype is msword, i.e. application/msword.

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.

The basic difference between ASP and ASP.NET is that ASP is interpreted; whereas, ASP.NET is compiled. This implies that since ASP uses VBScript; therefore, when an ASP page is executed, it is interpreted. On the other hand, ASP.NET uses .NET languages, such as C# and VB.NET, which are compiled to Microsoft Intermediate Language (MSIL).

Depending upon the increase or decrease in price rates, buyers may respond accordingly. Some buyers may assume that quality of the product may have reduced to to reduction in price or that the company may not be selling the product as per expectations. The other assumption that buyers may make is that prices may go down in the future and so may delay purchase. On the other hand increased price may lead to a decrease in demand as the product may be more costly for the consumers who may switch to another seller offering similar products at lower prices.

Selling the rights to the amounts owing by debtors to a finance company for an agreed amount (which is less than the figure at which they are recorded in the accounting books because the finance company needs to be paid for providing the service).

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.