Interview Questions

They are DEFINE CLUSTER, DATA and INDEX.

Primary key : a relational database constraint. Primary key consists of one or more columns that uniquely identify a row in the table. For a normalized relation, there is one designated primary key.

Unique index: a physical object that stores only unique values. There can be one or more unique indexes on a table.

When we create string with new() Operator, it’s created in heap and not added into string pool while String created using literal are created in String pool itself which exists in PermGen area of heap.

String s = new String("Test");

does not put the object in String pool , we need to call String.intern() method which is used to put them into String pool explicitly. its only when you create String object as String literal e.g. String s = "Test" Java automatically put that into String pool.

Following are the benefits of data integration:

- Makes reporting, monitoring, placing customer information across the enterprise flexible and convenient.

- Data usage is efficient.

- Cost Effective.

- Risk adjusted profitability management as it allows accurate data extraction.

- Allows timely and reliable reporting, as data quality is the prime technology for business challenges.

We can tune the report by using index awarness in universe

It can be done by setting the record length’s size to more than half of the page’s size.

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 ::