Interview Questions

Inflation risk, also called purchasing power risk, is the chance that the cash flows from an investment won't be worth as much in the future because of changes in purchasing power due to inflation.

HOW IT WORKS (EXAMPLE):

For example, $1,000,000 in bonds with a 10% coupon might generate enough interest payments for a retiree to live on, but with an annual 3% inflation rate, every $1,000 produced by the portfolio will only be worth $970 next year and about $940 the year after that. The rising inflation means that the interest payments have less and less purchasing power. And the principal, when it is repaid after several years, will buy substantially less than it did when the investor first purchased the bonds.

Aggregate functions perform a calculation on a set of values and return a single value. Aggregate functions ignore NULL values except COUNT function. HAVING clause is used, along with GROUP BY, for filtering query using aggregate values.

Following functions are aggregate functions. 

AVG, MIN CHECKSUM_AGG, SUM, COUNT, STDEV, COUNT_BIG, STDEVP, GROUPING, VAR, MAX. VARP

The standard query operators in LINQ are the extension methods that form the LINQ pattern. These operators form an API that enables querying of any .NET array or collection. It operates on sequences and allows you to perform operations, such as determining if a value exists in the sequence and performing an aggregated function, such as a summation over a sequence.

Authorization: The process of granting access privileges to resources or tasks within an

application.

Authentication: The process of validating the identity of a user.

A savings vehicle is a bank account that's used to hold your savings.

The basic saving vehicles include :

Savings accounts,

Money market accounts,

Certificates of deposit, and

Stock market.

Dropped tables can be recovered using DROP TABLE flashback. It works the way recycle bin works.
Example:
FLASHBACK TABLE EMPLOYEE TO BEFORE DROP;
The most recently dropped table with that original name is retrieved from the recycle bin, with its original name.

READNEXT reads the next record from a browse operation for any of the three VSAM files.