Interview Questions

Open for INPUT, OUTPUT, I-O, EXTEND.

1.INPUT : for read only purpose

2.OUTPUT : for write only purpose

3.EXTEND : for appending records

4.I-O : for read and write(using EXTEND) purpose

Similarity: Both WHERE and HAVING Clause filters out records based on one or more conditions.

Difference: WHERE Clause can only be applied to a static non-aggregated column whereas HAVING is needed for aggregated columns.

A certificate of deposit (CD) is a savings certificate with a fixed maturity date, specified fixed interest rate and can be issued in any denomination aside from minimum investment requirements.

CD's are generally issued by commercial banks

Undergraduates may get this question as feelers of their business knowledge. Insider trading describes the illegal activity of buying or selling stock based on information that is not public information. This is to prevent those with privileged information (company execs, I-bankers and lawyers) from using this information to make a tremendous amount of money unfairly.

 - When two processes are waiting to update the rows of a table which are locked by another process, the situation is called a deadlock.
 - The reasons for it to happen are:
 * lack of proper row lock commands.
 * Poor design of front-end application
- It reduces the performance of the server severely.
- These locks get automatically released automatically when a commit/rollback operation is performed or any process is killed externally.

ARC is a compiler-level feature that simplifies the process of managing the lifetimes of Objective-C objects. Instead of you having to remember when to retain or release an object, ARC evaluates the lifetime requirements of your objects and automatically inserts the appropriate method calls at compile time.

The tax payable on a non-salary benefit provided to an employee or an associate of the employee. The employer is liable to pay any FBT and may choose to recover the FBT amount from the employee.