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 are few of the schema objects that are created using PL/SQL?

555


What is the use of index in hive?

544


What is composite primary key in sql?

514


What are commit, rollback, and savepoint?

567


What is meaning of <> in sql?

581






What is left inner join in sql?

511


What is sql and its types?

625


What operating systems are supported by oracle sql developer?

518


What is sqlerrm?

540


How to handle bulk data?

889


Write the command to remove all players named sachin from the players table.

729


How do you remove duplicates without using distinct in sql?

499


What is user defined functions?

570


what are integrity rules?

563


What is before trigger?

546