shutdown TRANSACTIONAL:
Specifies that a transactional shutdown is to be performed. A transactional shutdown prevents new user logins and disconnects any user whose transaction is complete (i.e., no COMMIT is pending). As each remaining user completes the current transaction via a COMMIT or ROLLBACK statement, the session is disconnected. When all users are disconnected, the instance will be shut down.
so BCF
for D,E
The Instance Recovery will only happen if issuing shutdown abort or a crash.
B, D, F
B: Transactions that haven't been committed yet are allowed to finish before shutdown fully completes
D: Database will automatically check for any unfinished transactions and make sure everything is in a consistent state
F: New users trying to log in or start sessions will be denied access until the database is fully shut down and restarted
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
EddieY
2 weeks, 1 day agocf1f99b
1 month ago