What is the relation b/w view and trigger

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a full join?

704


Mention what pl/sql package consists of?

716


Why indexing is needed?

720


What is a primary key example?

692


Can we insert data in view?

688






Why we use triggers in mysql?

720


What do you mean by “trigger” in sql?

788


How do I run sql profiler?

758


What is the difference between explicit and implicit cursors in oracle?

687


What is user defined functions?

739


What do you mean by table in sql?

693


tell us something about heap tables. : Sql dba

812


what is blob? : Sql dba

731


Define union, minus, union all, intersect ?

735


What is column?

716