Oracle
1Z0-063 · Question #138
The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction. Which type of lock would this scenario lead to?
The correct answer is B. Row-exclusive lock on the row being updated. See the full explanation below for the reasoning.
Question
The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction. Which type of lock would this scenario lead to?
Options
- AExclusive table-level lock on the EMPLOYEES table
- BRow-exclusive lock on the row being updated
- CNull lock on the EMPLOYEES table
- DNull lock on the row being updated
How the community answered
(37 responses)- A3% (1)
- B78% (29)
- C8% (3)
- D11% (4)
Community Discussion
No community discussion yet for this question.