view is used to minimize the complex query of table(s), thru view we can do

What is the relation b/w view and trigger

Question Posted / vivekanandhan

3 Answers
16513 Views
Accenture, TCS, I also Faced
E-Mail Answers

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 sorting in sql?

941

Can you have more than one key in a database?

931

What is the difference between an inner and outer join?

1010

What is a crud api?

951

Are pl sql variables case sensitive?

1045

Explain the uses of control file.

1048

What is difference between cursor and trigger?

1070

What is the command used to fetch the first 5 characters of a string?

1207

How do you clear the screen in sql?

1064

Is sql difficult?

1148

how to use myisamchk to check or repair myisam tables? : Sql dba

968

Which one is faster ienumerable or iqueryable?

930

What is row_number () in sql?

978

Which is better join or subquery?

1132

how to check server status with 'mysqladmin'? : Sql dba

1073