The row will be inserted in…

Prev Question
Next Question

View the Exhibit and examine the data in the CUST_DET table.

Exam 1Z0-047 - The row will be inserted in…

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

Prev Question
Next Question

Leave a Reply

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