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 and After REORG with LOG NO

(Continued on next question...)

Other Job Interview Questions

• What is auditing
• If the base table underlying a view is restructured ...
• Explain the EXPLAIN statement ?
• What is lock escalation?
• In SPUFI suppose you want to selet maximum of 1000 rows ...
• What is the cascade rule and how does it relate to deletions made with a subselect ?
• What is filter factor?
• What are the disadvantages of PAGE level lock?
• Name some of field from SQLCA?
• What are delete-connected tables ?
• More...