Answer Posted / nitesh
It is mainly used in referential integrity constraints.
When you use primary key/candidate key of one relation(say,
r1) as foreign key in other relation(say, r2), you want
changes made to primary key/candidate key of r1 must reflect
in foreign key of r2. And this can be achieved by CASCADE
constraint.
eg. consider two relations account, branch(with primary key
branch_name)
create table account(.....
foreign key branch_name references branch
on delete cascade
on update cascade
..........)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain error and transaction handling in sql server?
What are commit and rollback in sql?
What is extent? Types of extents?
What do you understand by the denormalisation?
What is database replication? What are the different types of replication you can set up in sql server?
Why is sql server log file full?
Describe in brief sql server monitoring ways.
What is the security principal at the server level that represents your session?
How to connect Azure federated root database and apply federation in entity framework?
in the physical file layout, where should the transaction log be stored in relation to the data file?
What is sql server profiler trace data file?
Why would you call update statistics?
What is the difference between primary key and unique constraints?
How many types of triggers in sql server?
Explain four layers of abstraction microsoft architectured?
