Answer Posted / saraswathi muthuraman
TO apply business rule we are using Constraints and trigger.
If we have any computation and validation over the
calculated value we have choose "trigger".
Direct validation like the column should not contain null
values then you can choose Constraints.
Constraints : NOT NULL,UNIQUE,PRIMARY KEY,CHECK,REFERENCE
Trigger effected only those row after which trigger applied
but constraint effected all row of table .
| Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
What is aggregate function in sql?
who introduced sql?
What is pragma in pl sql?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What is the difference between distinct and unique in sql?
Write a query to find the names of users that begin with "um" in sql?
List out the acid properties and explain?
how to do backup entire database? : Transact sql
Can I learn sql in a week?
What is the file extension for sql database?
How do you remove duplicate records from a table?
Explain the steps needed to create the scheduled job?
what is a composite key ? : Sql dba
What are the triggers associated with image items?
Can we create table inside stored procedure?
