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.
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.
Sandeep sharma said:
10 years ago
Answer is true if not then tell me.
Dipali said:
10 years ago
Answer is true. If it is false then please explain it.
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.
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?
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.
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.
Ashutosh said:
1 decade ago
Why not true?
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.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers