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

🎓
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
  • 200 Questions with Detailed Solutions
  • Section-wise Coverage (GA, English, Quant & Reasoning)