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 difference between stored function and application function?

0 Answers  

Which operator is used in query for pattern matching?

0 Answers  

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

What is bulk collections?

2 Answers  

How do I save the results of sql query in a file?

0 Answers  

what are the differences between char and varchar? : Sql dba

0 Answers  

what are the advantages and disadvantages of cascading style sheets? : Sql dba

0 Answers  

What is sql select statement?

0 Answers  

Write a sql query to find the names of employees that begin with ‘a’?

0 Answers  

What is a transaction?

5 Answers  

How the execution will be done in exceptions?

2 Answers  

List and explain the different types of join clauses supported in ansi-standard sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories