What is the difference between constraints and triggers?
Answer Posted / malini paul
1.Constraint is a statement about a database that is always
true.Whereas triggers constrain what a transaction can do.
2.Constrain applies to existing data in the table and any
statement that manipulates the table.Whereas Trigger does
not apply to data loaded before the trigger was created.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
mention different types of relationships in the dbms?
How to use clusters?
What is meant by datasource?
Define left outer join?
What are the requirements to use odbc connections in php scripts?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
List out the differences between the clustered index and non-clustered index in sql server?
Explain the cursor lock types?
What is an active database?
Name 3 ways to get an accurate count of the number of records in a table?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What is database replication? What are the different types of replication you can set up in sql server?
List some case manipulation functions in sql?
what kind of lan types do you know? : Sql server database administration
In which tcp/ip port does sql server run? Can it be changed?