Question

deletion is not possible if the row to be deleted is referred in the child table
a. yes
b. no​

Answer 1

Answer:

ans is:YES

Explanation:

NOT POSSIBLE

Answer 2

Answer:

Yes, deletion is not possible if the row to be deleted is referred in the child table

Explanation:

• Deletion of a row from a table having a child table is not possible because of referential integrity constraints.
• Consider R1 and R2 are two tables . K1 is the Primary key of R1 and  K2 is the foreign key of R2 referencing K1. For this scenario  , it is required that for every tuple(row) t2 in R2 there must be a tuple(row) t1 in R1 such that t1[K1]=t2[K2].this is called referential integrity constraints.
• If we try to delete this tuple(row) t1 from R1 the referential integrity constraints will restrict the deletion.