What is the physical storage length of each of t

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the physical storage length of each of the following DB2 data type

Q: What is the physical storage length of each of the following DB2 data types : DATE, TIME, TIMESTAMP?

AN:
DATE: 4bytes
TIME: 3bytes
TIMESTAMP: 10bytes

(Continued on next question...)

Other Job Interview Questions

• What is the picture clause of the null indicator variable?
• Explain transactions, commits and rollbacks in DB2?
• What is the Maximum normber of partitions that can be joined?
• an I alter a table when other user is selecting some columns ...
• What are the functions of Bind?
• How is the SUBSTR keyword used in SQL?
• What is the Manimum Length SQLCA and what is the content of SQLCABC?
• What is a Cartesian product?
• What is a DB2 catalog ?
• Name some of field from SQLCA?
• More...