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 = 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______________.

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 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 CREDI_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 *


ttwd80

ttwd80

how to view the exibit