Question

Table ORDERS has a foreign key CUST_ID referencing CUSTOMERS(CUST_I

  • D . What happens when you try to DELETE a customer who has existing orders, if ON DELETE is set to RESTRICT?
A The customer is deleted and all orders are also deleted automatically
B The customer is deleted and CUST_ID in orders is set to NULL
C The deletion is rejected due to referential integrity violation
D The customer record is moved to an archive table
E The orders are automatically reassigned to a default customer
Practice Next

Hey! Ask a query