Interview Questions

Check EIBRESP after the call or use the HANDLE condition.

- A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.

- A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR.

Someone who receives money in exchange for a promise to pay it back later is called a borrower1, and the person making the loan is the lender.

.NET Framework is a complete environment that allows developers to develop, run, and deploy the following applications:

 => Console applications
 => Windows Forms applications
 => Windows Presentation Foundation (WPF) applications
 => Web applications (ASP.NET applications)
 => Web services
 => Windows services
 => Service-oriented applications using Windows Communication Foundation (WCF)
 => Workflow-enabled applications using Windows Workflow Foundation (WF)

They are DEFINE CLUSTER, DATA and INDEX.

A child selector is used when you want to match an element that is the child of another specific element.
The parent and child selectors are separated by spaces.
The following selector locates an unordered list element within a paragraph element and makes a text within that element bold.

p > ul {font-weight: bold;}

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.