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

Answers were Sorted based on User's Feedback



If the base table underlying a view is restructured, eg. attributes are added, does the applicatio..

Answer / 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

If the base table underlying a view is restructured, eg. attributes are added, does the applicatio..

Answer / s

No, unless the application pgm needs to take advantage of
the new columns.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is an inner join, and an outer join ?

1 Answers   CTA,


What is meant by a unit of recovery?

1 Answers  


I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

8 Answers  


What are the functions of Bind?

2 Answers   Amdocs, IBM,


what is db2 restart?

1 Answers  


What is db2 connect?

1 Answers  


What is DB2 (IBM Database 2)?

3 Answers  


wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  


What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,


What are iseries servers?

1 Answers  


How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  


What happens in bind step in a db2 program?

1 Answers  


Categories