Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 are stage one indexable predicates?

1 Answers  


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,


A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,


Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,


Is ibm db2 free?

0 Answers  






What are some characteristics of columns that benefit from indexes?

1 Answers  


What is null indicator in db2?

0 Answers  


In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,


What is QUIESCE?

2 Answers  


What is usage pointer in cobol?

3 Answers   IBM,


Explain what a plan is?

3 Answers   CTS,


How can you display the current date & current time ?

7 Answers   Cap Gemini,






Categories