Interview Questions

Constraints enable the RDBMS to enforce the integrity of the database automatically, without the need to create triggers, rule or defaults.

Types of Constraints: NOT NULL, CHEQUE, UNIQUE, PRIMARY KEY, FOREIGN KEY.

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.

array_flip exchange the keys with their associated values in array ie. Keys becomes values and values becomes keys.

<?php
$arrayName    = array("course1"=>"php","course2"=>"html");
$new_array    = array_flip($arrayName);
print_r($new_array);
?>

OUTPUT :

Array
(
[php]     => course1
[html]    => course2
)

Comprehensive income is the sum of net income and other items that must bypass the income statement because they have not been realized, including items like an unrealized holding gain or loss from available for sale securities and foreign currency translation gains or losses.

Cursor_Already_Open,  Invalid_Cursor.

A JAR file (short for Java Archive) is a ZIP file used to distribute a set of Java classes. It is used to store compiled Java classes and associated metadata that can constitute a program

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.