Explain difference between sys.cat and sys.ibm?

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

(Continued from previous question...)

Explain difference between sys.cat and sys.ibm?

SysIBM.<tablenames> syscat.<tablenme>

1)Schema name SysIbm Schema name Syscat

2)we cannot change we can alter

3)- views of SysIbm.<tab>

(Continued on next question...)

Other Job Interview Questions

• Explain difference between sys.cat and sys.ibm?
• How do we unload the DB2 tables using JCL?
• Are views updateable ?
• Why SELECT * is not preferred in embedded SQL programs?
• What is the difference between primary key and unique index ?
• What else is there in the PLAN apart from the access path? –
• What do you mean by NOT NULL WITH DEFAULT? When will you use it?
• How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only )
• What are the 4 environments which can access DB2 ?
• Why SELECT * is not preferred in embedded SQL programs?
• More...