You executed the following multitable INSERT statement:

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________.

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



Leave a Reply 3

Your email address will not be published. Required fields are marked *


chalkmask

chalkmask

There is not enough information to answer this question.

user01

user01

I have seen only one single exhibit till now…it’s a pity

Milan

Milan

The table CUST_DET consists only of one record having credit_limit equal to 6000