Oracle
1Z0-032 · Question #2
In your HRDB database instance, a transaction is manipulating a large volume of data, and requires more space in the database buffer cache. What happens if the buffer cache fills up before the…
The correct answer is B. The uncommitted data in the cache is written to the data files. See the full explanation below for the reasoning.
Question
In your HRDB database instance, a transaction is manipulating a large volume of data, and requires more space in the database buffer cache. What happens if the buffer cache fills up before the transaction completes?
Options
- AAn implicit commit is issued.
- BThe uncommitted data in the cache is written to the data files.
- CThe database buffer cache dynamically grows to accommodate the changes.
- DThe command executed in the transaction to manipulate data fails, prompting you to commit first.
How the community answered
(46 responses)- A4% (2)
- B72% (33)
- C11% (5)
- D13% (6)
Community Discussion
No community discussion yet for this question.