IBM DB2 Question:
Download Questions PDF

A user
defined name that is the anchor for packages. It has not physical existence. Main usage is to group packages.

In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows.

Answer:

100 ( for successful completion of the query ), 0 (for successful COMMIT if AUTOCOMMIT is set to Yes).

Download IBM DB2 Interview Questions And Answers PDF

Previous QuestionNext Question
What is the self-referencing constraint?What is a clustering index ?