Are views updatable ?

Question Posted / guest

4 Answers
12812 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Are views updatable ?..

Answer / sadiq afroze

Not all of them. Some views are updatable e.g. single table
view with all the fields or mandatory fields. Examples of
non-updatable views are views which are joins, views that
contain aggregate functions (such as MIN), and views that
have GROUP BY clause.

Is This Answer Correct ?

9 Yes

0 No

Are views updatable ?..

Answer / purushothr

some views are updatable

Is This Answer Correct ?

2 Yes

0 No

Are views updatable ?..

Answer / shankar

Yes but only for those views which are created with UPDATE
option.

Is This Answer Correct ?

5 Yes

4 No

Are views updatable ?..

Answer / guest

yes

Is This Answer Correct ?

3 Yes

4 No

Post New Answer

More DB2 Interview Questions

Explain what are the various isolation levels possible?

0 Answers

What is dclgen (declaration generator)?

0 Answers

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers UST,

when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers IBM,

What is reorg and runstats in db2?

0 Answers

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers IBM, Tech Mahindra,

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers MCN Solutions,

Which component is responsible for db2 startup and shutdown?

0 Answers

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