Answer Posted / roopesh kumar
A trigger is a DB object like proc. or func. stored in data
dictonary. It will fire implicitly with event on which it
written.
Main use of a trigger are
-- we can take backup of data.
-- Can be used for auditing purpose.
-- For applying complex bussiness rule.
Etc.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Define data access layer?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
What is the difference between Command and CommandBuilder object?
Explain executenonquery?
Explain the role of data provider in ado.net?
What is ado.net and its architecture?
What is untyped dataset?
What are different layers of ADO.Net?
What is defaultview in datatable?
What is microsoft ado?
How would you connect to database using .NET?
What is ado net stands for?
Which is better ole db or odbc?
What is ado.net code?
differance between ADO vs ADO.Net?