Interview Questions

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

Amazon S3 provides uploading of large files and retrieve small offsets for end-to-end transfer data rates. The large file gets stored into small files that are smaller in size. Amazon S3 stores multiple of files together in a bundle or in a compressed form, For example in .gzip or .gz format and then convert them into Amazon S3 objects. The files get uploaded on the Amazon server by the use of FTP or another protocol and then retrieved through the HTTP GET request. The request includes the defined parameters like URL, offset (byte-range) and size (length).

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.

There are two payment types that will help you stick to your budget.

1. Cash
2. Debit Card

The amount in the debit card is the only amount you can spend to stay within budget.

These method work because once you spend your money, you are done. You don’t have anything else to spend.

Credit cards, payday loans, and cash advances are all loans on future income. When you use a credit card, there is always just a little bit more you can spend. These types do not help you budget properly. In fact, these types encourage you to spend beyond your means and be out of budget.

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

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.

EXECUTE IMMEDIATE command can be used to call DDL statements. 

Example:

BEGIN

EXECUTE IMMEDIATE  'TRUNCATE TABLE employee';

END;

The knowledge of Joins is a MUST for every interviewee. Most SQL programmers have used inner join and  outer join[left/right]; but the catch point here is to also mention cross join and self-join.