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

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 1

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


Matheus B. Nascimento

Matheus B. Nascimento

Exhibit:

CUST_ID | CREDIT_LIMIT | GRADE | GENDER
1 | 6000 | A | F