Q. Which of the following options you prefer if your business need to keep your TABLE data on "T1" intact but allows referencing table data on "T2" to be deleted. Assume a foreign key on T1 references an unique key on T2.
1) ON DELETE CASCADE
2) ON DELETE SET NULL
3) ON DELETE RESTRICT
ih u chhose cascade then the cirresponding child info will also be deleted when ever parent info iss deleted.but according to u the child info will not be deleted but it will be set to NULL.
RESTRICT WILL NOT ALLOW TO DELTE ANY RECORDS IN THE APRENT TABLE IF IT HAS CORRESPONDING R3ECORDS IN THE CHILD TABLE.