Database - Data Models into Database Designs - Discussion
Discussion Forum : Data Models into Database Designs - True or False (Q.No. 12)
12.
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
Discussion:
12 comments Page 1 of 2.
Sandhyarani said:
1 decade ago
Use the ON DELETE CASCADE option to specify whether you want rows deleted in a child table when corresponding rows are deleted in the parent table. If you do not specify cascading deletes, the default behavior of the database server prevents you from deleting data in a table if other tables reference it.
Sundar said:
1 decade ago
Cascade Update: A subsequent change to a record will automatically generate an update in all related records.
Cascade Delete: A subsequent deletion of a record will automatically cause a deletion of all related records.
Cascade Delete: A subsequent deletion of a record will automatically cause a deletion of all related records.
Guest said:
1 decade ago
The cascade update is On means when there is primary key relationship between table then it deletes the Data in child table when the parent table data is deleted.
Subhransu das said:
10 years ago
I think it should be true (lock it). As on delete cascade tells, child row will be automatically deleted when its associated parent row deletes.
Dileep said:
1 decade ago
Cascade delete automatically deletes all child rows when parent row is deleted.
So the answer should be true.
So the answer should be true.
Nidhi said:
10 years ago
Answer is false.
Because UPDATE is specially for change the data. And DELETE is remove unwanted rows.
Because UPDATE is specially for change the data. And DELETE is remove unwanted rows.
Narasimha reddy said:
1 decade ago
On delete cascade means when parent entity is deleted automatically it deletes child entity also.
Dipali said:
10 years ago
Answer is true. If it is false then please explain it.
Abhishek said:
1 decade ago
Can any one tell me what would be the final answer?
Gandhi said:
1 decade ago
Can any one give a perfect explanation?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers