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 rank () in sql?

0 Answers  

What is difference between % ROWTYPE and TYPE RECORD ?

2 Answers  

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

What are the types of keys?

0 Answers  

how to convert dates to character strings? : Sql dba

0 Answers  

Can we use commit inside a trigger?

0 Answers  

What are the 3 modes of parameter?

0 Answers  

How to avoid duplicate records in a query?

0 Answers  

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

Can you have a foreign key without a primary key?

0 Answers  

What is acid property in a database?

0 Answers  

What are inner and outer joins examples of both?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories