Interview Questions

Depreciation is a process of cost allocation, not valuation. In accounting, the term depreciation refers to the allocation of cost of a tangible asset to expense to the periods in which the asset is expected to be used to obtain the economic benefit.

In brief, Depreciation is fall in the value of assets due to wear and tear over a period of time, it is a loss.

The ServiceInstaller class, also known as the project installer class, is used to install a Windows service.

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.

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.

The number of distinct values for a column is called index cardinality. DB2's RUNSTATS utility analyzes column value redundancy to determine whether to use a tablespace or index scan to search for data.

A foreign key is a reference to another table. It is used to establish relationships between tables. For example, relationship between employee and professor table. One employee can have multiple professors. The Primary key of employee becomes foreign key of professor.
Example:
create table employee ( id number NOT NULL, professor_id NOT NULL, Name varchar(200) Constraint prim_id Foreign key(id) references professor(professor_id) );

1 : InnoDB provides us row level locking while MyISAM provides us table level locking.

2 : InnoDB offers foreign key constraints wheres in MyISAM does not have foreign key constraints.

3 : InnoDB does not have full text search wheres MyISAM provides us full text search.