YOU WANT TO INSERT A ROW AND THEN UPDATE IT. WHAT SEQUENCE OF STEPS...

4. You want to insert a row and then update it. What sequence of steps should

you follow? (Choose the best answer.)

A. INSERT, UPDATE, COMMIT

B. INSERT, COMMIT, UPDATE, COMMIT

C. INSERT, SELECT FOR UPDATE, UPDATE, COMMIT

D. INSERT, COMMIT, SELECT FOR UPDATE, UPDATE, COMMIT