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 types:

DATE, TIME, TIMESTAMP?
DATE: 4bytes
TIME: 3bytes
TIMESTAMP: 10bytes

(Continued on next question...)

Other Job Interview Questions

• What is the difference between primary key and unique index ?
• What else is there in the PLAN apart from the access path? –
• What is check pending and copy pending status in D...
• What do you need to do before you do EXPLAIN?
• Is there any advantage to denormalizing DB2 tables?
• What is DCLGEN ?
• What are aggregate functions?
• Lot of updates have been done on a table due to which indexes have gone haywire. What do you do? –
• What are the isolation levels possible ?
• What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
• More...