Exam 1z0-071 topic 1 question 213 discussion

The condition from subquery is same for all tables i.e. data from sub query comes with employee_id > 125 if the sal > 2000 then values will insert in Special_sal if the sal <2000 then values will insert in SAL_HISOTORY & MGR_HISTORY CHATGPT IS WRONG 100%. D is Correct

In INSERT ALL we can have multiple INTO clauses under conditional statements. So both INTO statement will be executed under ELSE condition.

Using chatgpt4, answer given is C. someone pls verify Expected Outcome Based on Conditions: For employee_id = 100 with salary = 25000: Meets SAL > 20000, so data is inserted into special_sal. Data is also inserted into mgr_history because the condition for the mgr_history table insertion doesn't depend on the salary. For employee_id = 110 with salary = 18000: Does not meet SAL > 20000, so data is inserted into sal_history. Data is also inserted into mgr_history regardless of the salary because there's no conditional logic preventing this in the provided statement. For employee_id = 120 with salary = 21000: Meets SAL > 20000, so data is inserted into special_sal. Data is also inserted into mgr_history regardless of the salary.

C is correct you can CHATGPT

D is correct