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

What is delimiter sql?

0 Answers  

what is purge command explain about oracle performance tuning

2 Answers   Accenture, eCentric Solutions,

How to check if a column is nullable before setting to nullable?

0 Answers  

what eliminate duplicate without using roenum and not

5 Answers   Matrix,

What are the features of pl sql?

0 Answers  

What is view explain with example?

0 Answers  

What is the clause we need to add in function body to return variable?

0 Answers  

Explain exception handling in pl/sql?

0 Answers  

Explain the uses of database trigger.

0 Answers  

can we call a procedure from a function?

9 Answers   Mind Tree,

How did you export data from database to excel file.

1 Answers   TCS,

Is a foreign key always unique?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories