Interview Questions

If you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate. When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates.

Trigger allows us to execute a batch of SQL code when an insert, update or delete command is executed against a specific table.

Triggers are special types of stored procedures that are defined to execute automatically in place of or after data modifications. They can be executed automatically on the insert, delete and update operation.

Compounding interest means interest accrues on the interest charged and the principal amount each period the interest is charged.

Compound interest is calculated by multiplying the principal amount by one plus the annual interest rate raised to the number of compound periods minus one.The total initial amount of the loan is then subtracted from the resulting value.

The formula for calculating compound interest is:

[P (1 + i)n] – P

= P [(1 + i)n – 1]

(Where P = Principal, i = nominal annual interest rate in percentage terms, and n = number of compounding periods.)

Take a three-year loan of Rs. 10,000 at an interest rate of 5% that compounds annually. What would be the amount of interest? In this case, it would be:

Rs. 10,000 [(1 + 0.05)3] – 1

= 10,000 [1.157625 – 1]

= Rs. 1,576.25.

How it grows ::

To make this method available to every implementation class

Yes the object is retained. It creates a timer that calls a selector on the current threads run loop. It may not be 100% precise time-wise as it attempts to dequeue the message from the run loop and perform the selector.

The job cost sheets constitute the subsidiary ledger for the Work in Process Inventory Account.

A job cost sheet is a form used to record the costs chargeable to a specific job and to determine the total and unit costs of the completed job. Companies keep a separate job cost sheet for each job.

The knowledge of Joins is a MUST for every interviewee. Most SQL programmers have used inner join and  outer join[left/right]; but the catch point here is to also mention cross join and self-join.

 Accounts receivables help small businesses by providing quick-time period liquidity. Additionally continued sales on credit provide the  much-needed continuity for small companies.