Home Interview Questions and AnswersTechnical Interview Questions and AnswersDB2 DB2 Interview Questions and Answers For Freshers Part-2

db211.In a COBOL-DB2 program all SQL statements must be coded in Area A. State whether true or false?

This statement is incorrect as SQL statements must be coded in Area B.

12.Cursors are used to handle single row selections at a time. They are data structure which hold all the results of a query. State whether true or false?
This statement is incorrect as cursors are used to handle multiple row selections at a time.

13.Host variables cannot be group items but they may be grouped together in host structure. They can be Renamed or Redefined. State whether true or false?
This statement is incorrect as host variables cannot be renamed & redefined.

14.When a table is dropped all the alias get dropped automatically. State whether true or false?
This statement is incorrect. Synonyms get dropped automatically when we drop the table but alias of the table remains there. We need to manually drop the alias.

15.What action DB2 takes when a program abends?
When a program abends in middle of some transaction then DB2 performs a auto rollback.

16.If a transaction takes a Update lock on some data, then other transactions can get what type of lock?
If a transaction takes an Update lock on some data, then other transactions can only get only Shared lock on it.

17.If a transaction takes a Shared lock on some data, then other transactions can get what type of lock?
If a transaction takes a Shared lock on some data, then other transactions can get either a Shared or Update lock on it.

18.How the locks can be classified?
Locks can be classified based on size, duration and mode.

19.Which utility is used to load data into a table from a sequential file?
Load utility is used to load data into tables.

20.Which utility reclaims space from pages when some rows were deleted?
Reorg utility is used for reorganization of data on physical storage.

You may also like

Leave a Comment