Answer Happy

View the Exhibit and examine the data in the CUST_DET table.You executed the following multitable INSERT statement:INSERT FIRST -WHEN credit_limit >= 5000 THEN -INTO cust_1 VALUES(cust_id, credit_limit, grade, gender)WHEN grade = THE -INTO cust_2 VALUES(cust_id, credit_limit, grade, gender)WHEN gender = THE -INTO cust_3 VALUES(cust_id, credit_limit, grade, gender)INTO cust_4 VALUES(cust_id, credit_limit, grade, gender)ELSE -INTO cust_5 VALUES(cust_id, credit_limit, grade, gender)SELECT * FROM cust_det;The row will be inserted in________.

A. CUST_1 table only because CREDIT_LIMIT condition is satisfied
B. CUST_1 and CUST_2 tables because CREDIT_LIMIT and GRADE conditions are satisfied
C. CUST_1 ,CUST_2 and CUST_5 tables because CREDIT_LIMIT and GRADE conditions are satisfied but GENDER condition is not satisfied
D. CUST 1, CUST 2 and CUST 4 tables because CREDIT LIMIT and GRADE conditions are satisfied for CUST 1 and CUST 2, and CUST 4 has no condition on it