If the base table underlying a view is restructu

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

(Continued from previous question...)

If the base table underlying a view is restructured ...

Q: If the base table underlying a view is restructured, e.g. attributes are added, does the application code accessing the view need to be redone?

AN:
No. The table and its view are created a new, but the programs accessing the view do not need to be changed if the view and attributes accessed remain the same.

(Continued on next question...)

Other Job Interview Questions

• What is the database descriptor?
• In terms of DB2 indexing, what is the root page ?
• What is dynamic SQL?
• What is a DBRM, PLAN?
• How do you insert a record with a nullable colunm?
• What is the cascade rule and how does it relate to deletions made with a subselect ?
• What is a host variable?
• In SPUFI suppose you want to selet maximum of 1000 rows ...
• What technique is used to retrieve data from more than one table in a single SQL statement?
• Is there any advantage to denormalizing DB2 tables ?
• More...