When do you use the IMAGECOPY? – –

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

(Continued from previous question...)

When do you use the IMAGECOPY? – –

To take routine backup of tables
After a LOAD with LOG NO
After REORG with LOG NO

(Continued on next question...)

Other Job Interview Questions

• How to increase table space in DB2?
• How do you insert a record with a nullable column?
• What does the sqlcode of -818 pertain to? –
• What is stored in tables under creator SYSIBM?
• Can you use MAX on a CHAR column?
• What are simple, segmented and partitioned table spaces ?
• What is ACQUIRE/RELEASE in BIND?
• What happens to the PLAN if index used by it is dropped?
• What is a synonym? How is it used?
• My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?
• More...