Interview Questions

The real interest rate is the percentage increase in purchasing power that the lender receives on a loan. A decline in the real interest rate will increase the amount of investment spending.

Bull market is that market where stock value are expected rise and people will have tendency to sell their stock so as to earn profit out of it. Thus sudden push from the suppliers will gradually niutalise the market.

Whenever there is local- variable/parameter inside the method with same name as data member.

Ex:

Class Sample {

 int a;

  void show() {

   int a=5;

   system.out.println(a); // 5

   system.out.println(this.a);//23

  }

}

class MainApp {

  Public static void main(String[] args) {

  Sample s = new Sample();

   s.a = 23;

   s.show();

   }

}

SSIS, SSAS and SSRS are the most important reporting systems that BI professionals work with. On a detailed level, I have worked with data mining, master data management, data profiling and data cleansing and analysis.

Ping

Netstat

The Business Application Support (BAS) functional area at SLAC provides administrative computing services to the Business Services Division and Human Resources Department. We are responsible for software development and maintenance of the PeopleSoft applications and consultation to customers with their computer-related tasks.

It's called Broadcast Agent Server. Its function is torun the jobs or reports scheduled and can be monitored using Broadcast Agent Console.

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