Which of the following is true of Oracle Database when the isolation level is set to Serializable?
A)It will update any row having an SCN greater than the Transaction SCN.
B)It will delete any row having an SCN greater than the Transaction SCN.
C)It will read any row having an SCN greater than the Transaction SCN.
D)It will wait for a blocking transaction to release an exclusive lock.
E)It will not generate an error if the transaction must be rolled back.

Question

Quizplus · Accepted Answer

When the isolation level is set to Serializable, Oracle Database will wait for a blocking transaction to release an exclusive lock. This ensures that transactions are performed in an order that preserves their serializability, rather than concurrently. It does not update or delete any row automatically, nor does it read rows based on their SCN value. And if a transaction must be rolled back, Oracle Database will generate an error to indicate it cannot be completed.

Which of the Following Is True of Oracle Database When