Interview Questions

In most cases, the best answer to this question is answering yes. Working well under pressure is a good trait to have. However, I think if you answer that you work the same with pressure and without pressure, the interviewer will be more impressed. However, you will need to explain in words why this is better. Here are some of my answers.

1. "I work well under pressure because I use the pressure to help me work more efficiently."

2. "I enjoy working under pressure because I believe it helps me grow. In my previous experience, I always worked well during deadlines, and I always learned how to work more efficiently afterwards."

3. "I work well under pressure because I don't panic. I maintain self control and work as efficiently as possible. In all my experiences, I did well and I always enjoyed the experience."

At the time of updating the data warehouse, a lookup table is used. When placed on the fact table or warehouse based upon the primary key of the target, the update is takes place only by allowing new records or updated records depending upon the condition of lookup.

The materialized views are aggregate tables. It contains summarized data. For example, to generate sales reports on weekly or monthly or yearly basis instead of daily basis of an application, the date values are aggregated into week values, week values are aggregated into month values and month values into year values. To perform this process aggregate function is used.

The Debit balance recovery is usually made by raising a credit memo for the regular vendors. However if there are no future transactions from the supplier, we ask the vendor to send the check / make an EFT for the amount due from him.

Internal Rate of Return is that rate of Return at which the net present value is equal to Zero or it is the Rate which equates the present value of the cash inflows to the cash outflows.

NPV = Cash Inflow - Cash outflow

NPV = Zero

A commercial bank is a type of bank that provides services such as accepting deposits, making business loans, and offering basic investment products.

Commercial bank can also refer to a bank or a division of a bank that mostly deals with deposits and loans from corporations or large businesses, as opposed to individual members of the public.

Capital expenditures are capitalized because of the timing of their estimated benefits – the lemonade stand will benefit the firm for many years. The employees’ work, on the other hand, benefits the period in which the wages are generated only and should be expensed then. This is what differentiates an asset from an expense.

Drop Ship refers to, a manufacturer shipping goods directly to one of its customers' customer (instead of delivering the goods to the customer that placed the order with the manufacturer).

This concept of shipping goods is called as drop ship, drop shipping or a drop shipment.

-  The process of having a copy of redo log files is called mirroring.
-  It is done by creating group of log files together. This ensures that LGWR automatically writes them to all the members of the current on-line redo log group.
-  In case a group fails, the database automatically switches over to the next group. It diminishes the performance.