Yes , we can update a view which is based on more than one table. And dat

can we update a view which is created from two tables

Question Posted / guest

Answer Posted / guest

Yes , we can update a view which is based on more than one
table. And data will get updated in base tables also.

Is This Answer Correct ?

21 Yes

28 No

Please Help Members By Posting Answers For Below Questions

What is pl sql architecture?

956

Is time a data type in sql?

901

what are the advantages a stored procedure? : Sql dba

975

What is sql and db2?

997

How do you identify a primary key?

1062

What is join view in sql?

944

Can we create index on primary key?

962

What is cascade in sql?

961

What is flag in sql?

1031

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1071

Are stored procedures faster than queries?

943

What is information schema in sql?

1070

What is Histogram?

1554

What is the most restrictive isolation level? : Transact sql

1083

What are the constraints available in sql?

1046