Interview Questions

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

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

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

.NET Framework provides enormous advantages to software developers in comparison to the advantages provided by other platforms. Microsoft has united various modern as well as existing technologies of software development in .NET Framework. These technologies are used by developers to develop highly efficient applications for modern as well as future business needs. The following are the key components of .NET Framework:

 =>   .NET Framework Class Library
 =>   Common Language Runtime
 =>   Dynamic Language Runtimes (DLR)
 =>   Application Domains
 =>   Runtime Host
 =>   Common Type System
 =>   Metadata and Self-Describing Components
 =>   Cross-Language Interoperability
 =>  .NET Framework Security
 =>   Profiling
 =>   Side-by-Side Execution

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.

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.