Interview Questions

Q:

When is the finalize() called ? What is the purpose of finalization ?

Answer

The finalize method is called by the garbage collector, just before releasing the object’s memory. It is normally advised to release resources held by the object inside the finalize method.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

1 4016
Q:

What do you mean by a deadlock?

Answer

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

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 4010
Q:

State one similarity and difference between WHERE Clause and HAVING Clause?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 4010
Q:

What COBOL construct is the COBOL II EVALUATE meant to replace?

Answer

EVALUATE can be used in place of the nested IF THEN ELSE statements.

Report Error

View answer Workspace Report Error Discuss

0 4009
Q:

What is ‘Amortization’?

Answer

The repayment of the loan by instalment to cover principal amount with interest is known as ‘Amortization’.


 

Report Error

View answer Workspace Report Error Discuss

Subject: Bank Interview

0 4006
Q:

What do you know about the big-O notation and can you give some examples with respect to different data structures ?

Answer

The Big-O notation simply describes how well an algorithm scales or performs in the worst case scenario as the number of elements in a data structure increases. The Big-O notation can also be used to describe other behavior such as memory consumption. Since the collection classes are actually data structures, we usually use the Big-O notation to chose the best implementation to use, based on time, memory and performance. Big-O notation can give a good indication about performance for large amounts of data.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 3997
Q:

What is FBT (Fringe Benefit Tax)?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

Subject: Accounts Payable

3 3988
Q:

What is PHP's mysqli Extension?

Answer

The mysqli extension , or as it is sometimes known, the MYSQL improved extension ,was developed to take advantage of new features found in MYSQL systems versions 4.1.3 and later.

The mysqli extension has a number of benfits,the key enhancements over the mysql extension being:
=> Object-oriented interface
=> Support for prepared statements
=> Support for multiple statements
=> Support for transactions
=> Enhanced debugging capabilities
=> Embedded server support

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 3986