Interview Questions

A cookie is a small text file on the client machine either in the client’s file system or memory of client browser session.

SELECT * FROM table_name ORDER BY column_name desc Fetch first 5 rows only;

.NET’s Base class library exists in order to encapsulate huge number of common functions and makes them easily accessible to the developer. .NET base class library provides the functionality like ADO.NET, XML, Threading, IO, Security, Diagnostics, Resources, Globalization, collections etc. It serves as the main point of interaction between developer and runtime.

setcookie('variable','value','time');
variable - name of the cookie variable
value     - value of the cookie variable
time       - expiry time

Example:
<?php
setcookie('Test',$i,time()+3600);
?>
Test - cookie variable name
$i - value of the variable 'Test'
time()+3600 - denotes that the cookie will expire after an one hour

You should have recorded in your cash books all amounts you?ve actually received and payments you?ve actually made. However, the cash books may be incomplete as your bank may have put extra transactions through your account, such as:

bank fees or interest charges
direct debits (payments) and direct credits (receipts).
Doing a regular bank reconciliation will allow you to:

take into account any extra transactions your bank puts through your account, and
check and record any errors or omissions.
By regularly doing a bank reconciliation (say monthly) you can be more confident that your records contain all the information you need to prepare your income tax return and activity statements.

reconciliation- This is a statement prepared to find the reason for difference in any two balance.
eg 1)bank reconciliation is prepared to find the reason of difference between the passbook & cash book balance
2)Stock reconciliation is prepared to the reason of difference between the physical balance & book balance or to find the stock balance as on certain date.
etc

Secondary market refers to market where securities are traded after being initially offered to the public in the primary market and/or listed on the stock exchange.

Both these are used to combine the results of different SELECT statements.

    UNION       - Selects only distinct values 

    UNION ALL - Selects duplicate values also

Syntax:

    SELECT column_name(s) FROM table1

    UNION / UNION ALL

    SELECT column_name(s) FROM table2;

Notice that each SELECT statement within the UNION must have the same number of columns. The columns must also have similar data types. Also, the columns in each SELECT statement must be in the same order.

'ViewState' is specific to a page in a session.
'SessionState' is specific to user specific data that can be accessed across all pages in the web application.