Which DB2 catalog tables are used to produce a l

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

(Continued from previous question...)

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

The catalog tables to use are the SYSIBM.SYSTABKES and the SYSIBM.SYSCOLUMNS.

(Continued on next question...)

Other Job Interview Questions

• What is a Resource Control Table (RCT)? Describe its characteristics.
• What are foreign keys?
• What is the format (internal layout) of "TIMESTAMP"?
• What is a synonym?
• What is a lock?
• Describe the elements of the SELECT Query syntax?
• How to define the data items to receive the fetch items for the SQL?
• What are the disadvantages of using VARCHAR ?
• Which catalog tables contain authorization information?
• B37 abend during SPUFI
• More...