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.
Narasimha reddy said:
1 decade ago
On delete cascade means when parent entity is deleted automatically it deletes child entity also.
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.
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.
Ashutosh said:
1 decade ago
Why not true?
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.
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.
Gandhi said:
1 decade ago
Can any one give a perfect explanation?
Abhishek said:
1 decade ago
Can any one tell me what would be the final answer?
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.
Dipali said:
10 years ago
Answer is true. If it is false then please explain it.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers