4.
|
You have decided to give all of your employees a five percent raise. What Oracle mechanism will result in the fewest lock resources
being used?
Please select the best answer.
|
|
A.
|
Select all rows in the table with the FOR UPDATE clause.
|
|
B.
|
Issue the LOCK TABLE command before the update.
|
|
C.
|
Just issue the update and let Oracle handle the locks.
|
|
D.
|
Place the update in a PL/SQL cursor and commit after every 50 updates.
|