PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

A.
no rows are unlocked

B.
nine rows are unlocked

C.
six rows are unlocked

D.
all rows are unlocked


Leave a Reply