Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Can a view be updated/inserted/deleted?If Yes under what
conditions?

Question Posted / guest

Answers were Sorted based on User's Feedback



Can a view be updated/inserted/deleted?If Yes under what conditions?..

Answer / guest

A View can be updated/deleted/inserted if it has only one
base table if the view is based on columns from one or
more tables then insert, update and delete is not possible.

Is This Answer Correct ?    6 Yes 2 No

Can a view be updated/inserted/deleted?If Yes under what conditions?..

Answer / anurag

Also with the help of instead of trigger we can update the
view

Is This Answer Correct ?    4 Yes 0 No

Can a view be updated/inserted/deleted?If Yes under what conditions?..

Answer / swapnareddy

A View can be updated/deleted/inserted if it has only one
base table if the view is based on columns from one or
more tables then insert, update and delete is possible with
thehelp of instead of trigger.

Is This Answer Correct ?    5 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

Is it possible for a table to have more than one foreign key?

0 Answers  

Do we need to rebuild index after truncate?

0 Answers  

What is the use of sqldataadapter?

0 Answers  

How do we use distinct statement? What is its use?

0 Answers  

What is a data manipulation language?

0 Answers  

what the meaning of sql

8 Answers  

What is the basic form of sql query?

0 Answers  

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

What company owns postgresql?

0 Answers  

What is a dynamic query?

0 Answers  

Where the Pre_defined_exceptions are stored ?

2 Answers  

What is varchar data type in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories