|
#713. There are two users, John and Susan, who are updating the EMPLOYEE table in the following order:
1. First, John issues this SQL update:
UPDATE EMPLOYEE SET LAST_NAME = ‘SMITH’ WHERE ID=200;
2. Next, Susan issues this SQL update:
UPDATE EMPLOYEE SET SALARY=50000 WHERE ID=250;
3. Next, John issues this SQL update:
UPDATE EMPLOYEE SET LAST_NAME ‘BAKER’ WHERE ID=250;
4. FINALLY, Susan issues this SQL update:
UPDATE EMPLOYEE SET SALARY=60000 WHERE ID=200;
What will be the result?
Show comments for this question (1)
Add comments
Link to this question
|
gen. 0.51
Forum
Master braindump