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

What is the relation b/w view and trigger

Question Posted / ashok

Answers were Sorted based on User's Feedback



What is the relation b/w view and trigger..

Answer / rajesh venati

View are classified in to two types.
1. Simple View
2. Complex View

==>DML Operations are not possible in complex views, because,
if u create a view more than one table or
if u create a view using group function or
if u create a view using distinct keyword etc.,
those are called complex view.

If u want perform DML Operations on Complex Views, then we
will go for Instead of Trigger.

Through the Instead of Triggers we can perform DML
Operations on a Complex View.

Is This Answer Correct ?    31 Yes 1 No

What is the relation b/w view and trigger..

Answer / bmk

Both are database objects and it behaves diff.View doesn't
contain data and tied with sql.Trigger is an event,trigger
will create on table with after/before with DML operations.

Is This Answer Correct ?    4 Yes 0 No

What is the relation b/w view and trigger..

Answer / vivekanandhan

view is used to minimize the complex query of table(s), thru view we can do insert,update,delete where as trigger is an event which will execute automatically when any DML operations provided against the table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

how to use like conditions? : Sql dba

0 Answers  

What is range partitioning?

0 Answers  

How do you determine the current isolation level? : Transact sql

0 Answers  

what is self join and why is it required? : Sql dba

1 Answers  

what is the Default Libraries for Oracle Report 6i

0 Answers   IBM,

how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?

1 Answers  

What is sql server and ase?

0 Answers  

Can cursors be part of a trigger body?

0 Answers  

What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

Which tcp/ip port does sql server run?

0 Answers  

Which is the best place to learn hadoop?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories