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

Answer Posted / s

No, unless the new columns should be made part of the view,
the view needs to be regenerated.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why select is not preferred in embedded sql programs?

697


What is the use of commit in db2?

622


Is db2 a mainframe database?

555


What are the various data types available in db2?

624


What is null indicator in db2?

590






What is db2 look?

565


What is the role of data manager in the db2 database?

631


What are the various isolation levels possible?

637


What is database manager in db2?

539


What do you mean by commit and rollback?

586


Explain dclgen.

712


List out the three types of page locks that can be held.

676


How do you stop a db2 database in linux?

558


What is commit in db2?

587


How to restart a DB2 program?

1349