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 = THEN INTO cust_2
VALUES(cust_id, credit_limit, grade, gender) WHEN grade = THEN 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(cus_id, credit_limit, grade, gender) SELECT *
FROM cust_det; The row will be inserted in______________.
A.
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
B.
CUST_1 table only because CREDIT_LIMIT condition is satisfied
C.
CUST_1 and CUST_2 tables because CREDIT_LIMIT and GRADE conditions are
satisfied
D.
CUST_1, CUST_2 and CUST_5 tables because CREDI_LIMIT and GRADE conditions
are satisfied but GENDER condition is not satisfied