1Z0-047 · Question #148
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…
The correct answer is A. CUST_1 table only because CREDIT_LIMIT condition is satisfied. See the full explanation below for the reasoning.
Question
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________.
Options
- ACUST_1 table only because CREDIT_LIMIT condition is satisfied
- BCUST_1 and CUST_2 tables because CREDIT_LIMIT and GRADE conditions are satisfied
- CCUST_1,CUST_2 and CUST_5 tables because CREDIT_LIMIT and GRADE conditions are satisfied
- DCUST_1, CUST_2 and CUST_4 tables because CREDIT_LIMIT and GRADE conditions are satisfied
How the community answered
(31 responses)- A81% (25)
- B3% (1)
- C13% (4)
- D3% (1)
Community Discussion
No community discussion yet for this question.