If I have a view which is a join of two or more tables, can
this view be updatable?

Answers were Sorted based on User's Feedback



If I have a view which is a join of two or more tables, can this view be updatable?..

Answer / guest

If view has join that time view can not be updatable.

Is This Answer Correct ?    3 Yes 0 No

If I have a view which is a join of two or more tables, can this view be updatable?..

Answer / sudha

no

Is This Answer Correct ?    3 Yes 1 No

If I have a view which is a join of two or more tables, can this view be updatable?..

Answer / mahesh vasudevan

One can not make update operation on a view that has a join
from more than two or more tables.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is the difference between Primary key and unique index?

6 Answers  


How would you find out the total number of rows in a db2 table?

0 Answers  


what is + sign and -ve sign for sql code ?

1 Answers   TCS,


How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,


What is a db2 package?

0 Answers  






how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,


What is check constraint. Explain with example.

0 Answers  


could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

5 Answers  


Which transaction use a command thread ?

1 Answers  


What information is used as input to the bind process?

2 Answers  


When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  


What Utility is used to migrate DB2 from one release to the next?

1 Answers  


Categories