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
There is not enough information to answer this question.
I have seen only one single exhibit till now…it’s a pity
The table CUST_DET consists only of one record having credit_limit equal to 6000