Interview Questions

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

MainMenu component is a component that allows the display of Menus at runtime on a form.

Process of creating Menu using MainMenu Component:

a. Add MainMenu component on Windows Form.

b. Menu designer allows deciding the structure of the main menu by selecting the Type Here area and adding the Menu Items to be displayed on the menu.

c. Add functionality to Menu Items as required

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

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.