Oracle Database 12c: Installation and Administration — Question 162

An employee salary in the non-partitioned EMPLOYEES table, has been updated but the transaction is uncommitted.
Which two types of lock are held by the transaction? (Choose two.)

Answer options

• A. a row level lock on the row being updated
• B. a null lock on the row being updated
• C. a row shared lock on the EMPLOYEES table
• D. an exclusive lock on the EMPLOYEES table
• E. a null lock on the EMPLOYEES table

Correct answer: A, C

Explanation

The correct answers are A and C because the transaction holds a row level lock on the specific row being modified and a shared lock on the EMPLOYEES table to prevent other transactions from making conflicting updates. Options B, D, and E are incorrect as they either describe nonexistent locks in this context or do not apply to the situation of an uncommitted transaction.