HP Exam Questions

How does the FREE RESOURCES statement change the locks on the table?

An SQL application has an updatable cursor open against an audited table which uses
REPEATABLE access. The application updates every third row that it reads and it has updated
three rows. How does the FREE RESOURCES statement change the locks on the table?

A.
no rows are unlocked

B.
nine rows are unlocked

C.
six rows are unlocked

D.
all rows are unlocked