The row will be inserted in…

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

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



Leave a Reply 2

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


user

user

The syntax is messy (WHEN grade = ??)…

Tomek

Tomek

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;