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.)
A. All active transactions are rolled back and the database instance shuts down.
B. The database instance status is automatically changed to RESTRICTED mode and file creation in the fast recovery area is prevented.
C. The Oracle Database server deletes a file that is on the obsolete file list to create free space in the fast recovery area.
D. An entry is written in the alert log and the database instance is automatically placed in MOUNT state.
E. The log switch hangs until free space is available in the fast recovery area.
|
Download Printable PDF. VALID exam to help you PASS. |
 |