41. Which field in SQLCA shows the number of updated rows after update statement?
Check the value of SQLERRD to know how many rows got updated after an update statement.

42. What is the physical storage length of TIMESTAMP data type?
TIMESTAMP data type takes 10 bytes and default is YYYY-MM-DD:HH:MM:SS-NNNNNN

43. What is the physical storage length of DATE data type?
DATE data types take 4 bytes and default is 'YYYY-MM-DD'

44. Which component is used to processes SQL statements and selects the access paths?
DB2 optimizer is used to select the access paths & to process the SQL queries.

45. 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.

46. 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.

47. 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.

48. 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.

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

50. 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.