Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Steven King's row in the EMPLOYEES table has EMPLOYEE _ ID = 1 0 0 and SALARY = 2 4 0 0 0 . A

Steven King's row in the EMPLOYEES table has EMPLOYEE_ID =100 and SALARY =24000. A user issues the following statements in the order shown:
UPDATE employees
SET salary = salary *2
WHERE employee_id =100;
COMMIT;
UPDATE employees
SET salary =30000
WHERE employee_id =100;
The user's database session now ends abnormally. What is now King's salary in the table?
Group of answer choices
30000
48000
24000
78000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Seven Databases In Seven Weeks A Guide To Modern Databases And The NoSQL Movement

Authors: Luc Perkins, Eric Redmond, Jim Wilson

2nd Edition

1680502530, 978-1680502534

More Books

Students also viewed these Databases questions

Question

11. Identify the stage of beyond duality in Gone With the Wind.

Answered: 1 week ago