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.)
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.
A. incorrect
After completion of all transactions, any client still connected to the instance is disconnected
B. correct
C. correct
D. correct
E. correct
F. incorrect
TRANSACTIONAL [LOCAL]
Performs a planned shutdown of an instance while allowing active transactions to complete first. It prevents clients from losing work without requiring all users to log off.
G. incorrect
The next startup of the database will not require any instance recovery procedures.
https://docs.oracle.com/cd/B28359_01/server.111/b31189/ch12042.htm
=> BCDE are correct answers
The Answer is BCDE
if shutdown transactional is give to sql the following will be under considoration
1. it did not allow new connection
2. waits until current transactions end i.e if commit or rollback is issued
3.not waits until current session end
BCDE for sure
G is not correct shutdown transaction is normal shutdown (Safe) unlike shutdown abort
upvoted 5 times
...
This section is not available anymore. Please use the main Exam Page.1z0-062 Exam Questions
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.
yuyasasa
Highly Voted 4 years, 11 months agooanhnph
Highly Voted 4 years, 10 months agodfabac
Most Recent 2 years, 12 months agoeskias
3 years, 8 months agoeskias
3 years, 8 months agoModasser
4 years, 4 months agodancymonkey
4 years, 9 months ago