You have a one-to-many relationship between the Salesperson table and the Orders

Question

You have a one-to-many relationship between the Salesperson table and the Orders table. You have enforced referential integrity by turning on cascade delete. What would happen if you deleted a salesperson record? A. The salesperson would be deleted and any orders that were assigned to that salesperson would be assigned to NULL. B. The delete would be blocked if the salesperson had any orders. C. The salesperson would be deleted and any orders that were assigned to that salesperson would be assigned to the default value. D. The salesperson would be deleted and any orders that were assigned to that salesperson would also be deleted.

Explanation / Answer

D. The salesperson would be deleted and any orders that were assigned to that salesperson would also be deleted.

The respective salesperson record will be deleted and all the orders assigned to that salesperson also along with it . The on cascade delete statement helps us do this , the definition is given as follows :

A foreign key with cascade delete means that if a record in the parent table is deleted, then the corresponding records in the child table will automatically be deleted. This is called a cascade delete in Oracle.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.