Oracle
1Z0-067 · Question #226
Your database is running in ARCHIVELOG mode. You observe that the fast recovery area does not have enough free space and there is no scope to add more space to it. Identify two events that can occur…
The correct answer is C. The Oracle Database server deletes a file that is on the obsolete file list to create free space in the E. The log switch hangs until free space is available in the fast recovery area. See the full explanation below for the reasoning.
Question
Your database is running in ARCHIVELOG mode. You observe that the fast recovery area does not have enough free space and there is no scope to add more space to it. Identify two events that can occur at the time of a log switch. (Choose two.)
Options
- AAll active transactions are rolled back and the database instance shuts down.
- BThe database instance status is automatically changed to RESTRICTED mode and file creation in
- CThe Oracle Database server deletes a file that is on the obsolete file list to create free space in the
- DAn entry is written in the alert log and the database instance is automatically placed in MOUNT
- EThe log switch hangs until free space is available in the fast recovery area.
How the community answered
(21 responses)- A19% (4)
- B5% (1)
- C71% (15)
- D5% (1)
Community Discussion
No community discussion yet for this question.