+91 90691 39140 | +1 253 214 3115 | info@hub4tech.com | hub4tech

DB2 Interview Questions and Answers

1
What is SQLCA?
  • SQLCA stands for SQL Communication Area
  • SQLCA is a structure of variables which are updated after every SQL statement’s execution
  • Exactly only one SQLCA need to be provided to an application that contains executable SQL statements
  • SQLCA is not applicable to JAVA application
  • More than one SQLCA need to be provided for FORTRAN application
2
Define DB2.

DB2 is a Database Management System for the MVS Operating System where, DB2 is a subsystem of MVS Operating System.

3
What does it mean if the null indicator has -1,0,2?
  • -1 indicates the field is null
  • 0 indicates the field is not null
  • 2 indicates the field is truncated
4
What is concurrency?

More than one DB2 application process can access the same data at the same time, is known as concurrency. However, problems can happen such as, lost updates access to unrepeatable reads and uncommitted data.

5
What is the max length of SQLCA?

The maximum length of SQLCA is 136

Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.
FOLLOW US