The database needs to be shut down for hardware maintenance. All users sessions except one have either voluntarily logged off or have been forcibly killed. The one remaining user session is running a business critical data manipulation language (DML) statement and it must complete prior to shutting down the database.
Which shutdown statement prevents new user connections, logs off the remaining user, and shuts down the database after the DML statement completes?
A. SHUTDOWN
B. SHUTDOWN ABORT
C. SHUTDOWN NORMAL
D. SHUTDOWN IMMEDIATE
E. SHUTDOWN TRANSACTIONAL
Answer: E
What provides for recovery of data that has not been written to the data files prior to a failure?
A. redo log
B. undo segment
C. rollback segment
D. system tablespace
Answer: A
