USER JOHN UPDATES SOME ROWS AND ASKS USER ROOPESH TO LOG IN AND CHE...

6. User JOHN updates some rows and asks user ROOPESH to log in and check

the changes before he commits them. Which of the following statements is

true? (Choose the best answer.)

A. ROOPESH can see the changes but cannot alter them because JOHN will

have locked the rows.

B. ROOPESH will not be able to see the changes.

C. JOHN must commit the changes so that ROOPESH can see them and, if

necessary, roll them back.

D. JOHN must commit the changes so that ROOPESH can see them, but only

JOHN can roll them back.

Chapter 8: DML and Concurrency

363