Answer Posted / rami reddy.k
Triggers are the system generated events.
for example,
u have a table emp,in tat u can create a trigger which will
be activated if anyone performs any action such as insert,
update, delete on tat table.In tat trigger u can write code
which copies the updated info into another table.
A trigger is a stored procedure that goes into effect when
you insert, delete, or update data in a table. You can use
triggers to perform a number of automatic actions, such as
cascading changes through related tables, enforcing column
restrictions, comparing the results of data modifications,
and maintaining the referential integrity of data across a
database.
| Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
What are relationships and mention different types of relationships in the dbms
What is blocking?
How to backup SQL Server Reporting Services ?
How to create a scrollable cursor with the scroll option?
Explain how you can deploy an SSRS report?
How can you manage sql azure security?
Do you know what is normalization of database? What are its benefits?
how many type of indexing in database?
What are the difficulties faced in cube development? : sql server analysis services, ssas
Do you know nested transaction?
What is the language structure to add a record to a table?
What is trigger and different types of Triggers?
Who is the owner of a schema in ms sql server?
What is data file in computer?
What is the syntax to execute the sys.dm_db_missing_index_details?