Oracle
1Z0-032 · Question #2
1Z0-032 Question #2: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-032 to reveal the answer and full explanation for question #2. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-032 to see the answer
You've previewed enough free 1Z0-032 questions. Unlock 1Z0-032 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.