Oracle
1Z0-032 · Question #32
You are working on a database in which due to an instance failure all the transactions are terminated. As soon as the database opens, you want to access a row that is locked by a transaction, which…
The correct answer is A. Oracle server does this automatically. See the full explanation below for the reasoning.
Question
You are working on a database in which due to an instance failure all the transactions are terminated. As soon as the database opens, you want to access a row that is locked by a transaction, which was terminated. You want to access the row without waiting for all parts of the terminated transaction to be rolled back. How do you configure this phase of instance recovery?
Options
- AOracle server does this automatically.
- BIt is done by setting the RECOVERY_PARALLELISM parameter.
- CIt is done by setting the FAST_START_MTTR_TARGET parameter.
- DIt is done by setting the FAST_START_PARALLEL_ROLLBACK parameter.
How the community answered
(44 responses)- A77% (34)
- B14% (6)
- C7% (3)
- D2% (1)
Community Discussion
No community discussion yet for this question.