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
A