View the Exhibit and examine the data in the CUST_DET table.You executed the following multitable INSERT statement:INSER

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

View the Exhibit and examine the data in the CUST_DET table.You executed the following multitable INSERT statement:INSER

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply