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 scalar function in sql?

0 Answers  

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

How to change sql*plus system settings?

0 Answers  

Whis is not false in primary key?

0 Answers   Fintellix,

Why use truncate instead of delete?

0 Answers  

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

what is oracle sql,pl/sql with interfaces

2 Answers   TCS,

How to fix oracle error ora-00942: table or view does not exist

0 Answers  

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

check whether all the emp numbers are indeed unique.

6 Answers  

What is Overloading of procedures ?

4 Answers   Amdocs,

Mention what does the hierarchical profiler does?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories