Interview Questions

A company may also have various company codes across the different locations. There will be exchange of services between these company codes. These goods and services which are shared or exchanged between these company codes are bring to terms during the month end process. The exchange difference has to be settled by a company code in the way of money transfer.

This process is known as Intercompany Settlement. 

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

There are lots of ways to solve the issue of callback hells:

1. Modularization: break callbacks into independent functions
2. Use a control flow library, like async
3. Use generators with Promises
4. Use async/await (note that it is only available in the latest v7 release and not in the LTS version)

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.

EXECUTE IMMEDIATE command can be used to call DDL statements. 

Example:

BEGIN

EXECUTE IMMEDIATE  'TRUNCATE TABLE employee';

END;

There are four important files in order to make a bootable Windows XP operating system. These are Ntldr, Ntdetect, Boot.ini and Ntfs.sys

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.

In a SQL Database, a 'correlated subquery' is a kind of sub query yet connected subquery is dependent on another query for a value that is returned. In case of execution, the sub query is executed first and afterwards the correlated query will be executed.