IBM DB2 Question:

Download Job Interview Questions and Answers 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.

IBM DB2 Interview Question
IBM DB2 Interview Question

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 ?