What is a data type?

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

(Continued from previous question...)

What is a data type?

They are attributes of columns, literals, and host variables. The data types are SALLINT, INTEGER, FLOAT, DECIMAL, CHAR, VARCHAR, DATE and TIME.

(Continued on next question...)

Other Job Interview Questions

• What is the difference between primary key and unique index?
• Which DB2 command is used to retireve environmental information?
• What Utility is used to migrate DB2 from one release to the next?
• What is the physical storage length of each of the following DB2 data type
• What is a DB2 bind?
• Why use RUNSTAT Utility?
• Explain what a plan?
• What information is contained in a SYSCOPY entry?
• Are view updatable?
• What are delete-connected tables ?
• More...