Interview Questions

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

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

CURSOR STABILITY:

- CS is a row level locking

- Acquires an exclusive lock on the row that is to be updated

- When the control is moved to the next updatable row, the lock is released

REPEATABLE READ:

- RR is a page level locking

- Acquires an exclusive lock on the entire page which is the source of row availability

- When the control is moved to the next updatable page the lock is released

“In software testing, a test harness or automated test framework is a collection of software and test data configured to test a program unit by running it under varying conditions and monitor its behavior and outputs. It has two main parts: the test execution engine and the test script repository.”

Notices, Warnings and Fatal errors are the types of errors in PHP

Notices: 

Notices represents non-critical errors, i.e. accessing a variable that has not yet been defined. By default, such errors are not displayed to the user at all but whenever required, you can change this default behavior.

Warnings: 

Warnings are more serious errors but they do not result in script termination. i.e calling include() a file which does not exist. By default, these errors are displayed to the user.

Fatal errors: 

Fatal errors are critical errors i.e. calling a non-existent function or class. These errors cause the immediate termination of the script.

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

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.

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.