View the Exhibit and examine the data in the CUST_DET table.
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(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
The syntax is messy (WHEN grade = ??)…
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;