What can the Locate option of the Repair Utility

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

(Continued from previous question...)

What can the Locate option of the Repair Utility accomplish?

The Locate option of the Repair Utility can delete a row from a table space, repair broken table space pages, and replace data as specific locations in a table space or index.

(Continued on next question...)

Other Job Interview Questions

• What are the functions of Bind?
• What is the difference between Where and Having Clause ?
• What are the three DB2 date and time data types and their associated functions?
• What are the disadvantages of using VARCHAR ?
• How do you insert a record with a nullable colunm?
• What are the three tyes of page locks that can be held?
• Is DECLARE TABLE in DCLGEN necessary? Why it used?
• What is EXPLAIN?
• What is the easiest way to find out which programs are affected by change in a table's structure ??
• What is auditing
• More...