What is ALTER?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What is ALTER?

SQL command used to change the definition of DB2 objects.

(Continued on next question...)

Other Interview Questions

• What is a cursor ?
• What is the purpose of the WHENEVER statement?
• When is the authorization check on DB2 objects done - at BIND time or run time
• What are foreign keys?
• What is a synonym ? How is it used ?
• How would you move a tablespace to a different DASD volume allocated to that tablespace?
• What is the cascade rule and how does it relate to deletions made with a subselect ?
• What is a root page?
• What are the four lockable units for DB2?
• When do you specify the isolation level? How ?
• More...