Interview Questions

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.

These objects provide two levels of scope:

Application State

Data stored in the application object can be shared by all the sessions of the application.

Application object stores data in the key value pair.

The process of arranging any items in a systematic manner in a logical sequence is called as Sorting. It can be of two types :

1. Ordering

Arranging items following some criterion like ascending or descending order

2. Categorizing

Grouping items with similar properties together.

TDM is a digital process that can be applied when the data rate capacity of the transmission  medium is greater than the data rate required by the sending and receiving devices.

Bank Rate is the interest rate at which the RBI allows finance to commercial banks. By Bank Rate, we mean bank can regulate the level of economic activity.

Profitability control is a mechanism of monitoring the sales made, profits earned and expenditure incurred by a company. The relative profit earning capacity of a firm’s products and consumer groups can be determined via profitability control. Sometimes surpisingly, it may be found out by companies how a small proportion of their products and even customers actually account for a significant percentage of the company’s profits. This can be achieved through profitability control. At times when the companies earn surplus profits, then such profits may even be ploughed back or reinvested. This also forms part of profitability control.

Copy() makes a copy of the file. It returns TRUE on success. It can copy from any source to destination. Move simply Moves the file to destination if the file is valid. While move can move the uploaded file from temp server location to any destination on the server. If filename is a valid upload file, but cannot be moved for some reason, no action will occur.

A HTML form should be build before uploading the file. The following HTML code is used for selecting the file that is to be uploaded. The type attribute of input must be “file”.

<form enctype="multipart/form-data" action="uploader.php" method="POST">

<input type="hidden" name="MAX_FILE_SIZE" value="100000" />

Choose a file to upload: <input name="uploadedfile" type="file" /><br />

<input type="submit" value="Upload File" />

</form>

At the time of executing uploader.php, the uploaded file will be stored in a temporary storage are on the webserver. An associative array $_FILES['uploadedfile']['name'] is used for uploading. The ‘name’ is the original file that is to be uploaded. Another associative array $_FILES['uploadedfile']['tmp_name'] is used for placing the uploaded file in a temporary location on the server and the file should be empty and should exist with the tmp_name.

The following code snippet is used for uploading the file.

$target_path = "uploads/"; // the target location of the file

$target_path = $target_path . basename( $_FILES['uploadedfile']['name']);

if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) 

{

       echo "The file ". basename( $_FILES['uploadedfile']['name']). 

        " has been uploaded";

}

else

{

      echo “There was an error while uploading the file”;

}

The function move_uploaded_file()is used to place the source file into the destination folder, which resides on the server.

If the uploading is successful, the message “The file filename has been uploaded. Otherwise the error message “There was an error while uploading the file” would be displayed.