Interview Questions

The XML DOM (document object model) is used the access and management of xml. It is a platform that is language neutral and allows a program or a script to dynamically access a document. It also allows the updation of content as well as the structure and style of the document. It is responsible for the defining of the object and properties of all xml elements as well as to define the methods for their access. There are various methods that can be used in xml dom such as:

- getElementsByTagName: used to call a specific user defined tag.

- setAttribute: used to change the value of an existing attribute.

- appendChild: used to add a child node to another node.

A prompt box allows the user to enter input by providing a text box.

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

.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

A data warehouse is a relational database that is designed for query and analysis rather than transaction processing. It usually contains historical data that is derived from transaction data, but it can include data from other sources. Data warehouses are designed to help you analyze your data.

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.