Answer Posted / piyush
Triggers are those procedures written in PL/SQL that fire whenever one of the following operation occur, DML statements on a particular schema object, DDL statements issued within a schema or database, user log on or log off events, server errors, database startup, or instance shutdown.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain different forms of normalization?
Please differentiate between a local and a global temporary table?
How to use go command in "sqlcmd"?
Does server sql treat char as a variable-length or fixed-length column?
How you can find out if an index is useful to the optimizer?
Explain what is raid and what are different types of raid levels?
What is the purpose of sql profiler in sql server? : sql server database administration
What is the purpose of indexing?
What is the default value of an integer data type in sql server 2005?
What is the difference between index seek vs. Index scan?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What do you understand by physical_only option in dbcc checkdb?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is a benefit of using an after insert trigger over using a before insert trigger?
Is candidate a key?