1Z0-062 practice - PrepKeys

Q1 Multiple choice

Which four are true about the SHUTDOWN TRANSACTIONAL command and its effects in a single instance Oracle database environment with a single active transaction? (Choose four.)

Select all that apply.

A
The Oracle server waits for all sessions to disconnect before completing the shutdown.
B
An instance shutdown will occur if the transaction issues a COMMIT.
C
Sessions are unable to begin new transactions.
D
All sessions are terminated when the transaction ends.
E
An instance shutdown will occur if the transaction issues a ROLLBACK.
F
All the active transactions are rolled back and all user sessions are terminated.
G
The next startup requires instance recovery, which occurs automatically.