Oracle
1Z0-043 · Question #193
A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process (LGWR) at a log switch. How does this failure affect…
The correct answer is D. The database returns an error and the database instance shuts down. See the full explanation below for the reasoning.
Question
A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process (LGWR) at a log switch. How does this failure affect the operational database?
Options
- AThe database allows only queries; no other statements are allowed.
- BThe database re-creates the missing redo log files automatically.
- CThe database continues to function normally with the existing files.
- DThe database returns an error and the database instance shuts down.
- EThe user sessions that generate redo logs are terminated automatically.
How the community answered
(40 responses)- A3% (1)
- B5% (2)
- D80% (32)
- E13% (5)
Community Discussion
No community discussion yet for this question.