Your database instance is in the open state with uncommitted transactions. You plan to execute these commands: Which is true about the STARTUP command?
A.
It performs an instance recovery before opening the database in read/write mode
B.
It performs an instance recovery and leaves the database instance in mount state
C.
It opens the database in read-only mode
D.
It opens the database in read/write mode only if an spfile is used
I can suggest this one:
One of your databases is open and there are currently some uncommitted transactions.
You execute these commands successfully:
SHUTDOWN ABORT STARTUP
Which two are true about the effects of these commands?
A) Instance recovery occurs before the database Is opened read write.
B) Media recovery occurs and the database is left in mount state.
C) Instance recovery occurs before the database is opened read only
D) The uncommitted transactions are rolled back during startup
E) Media recovery occurs before the database Is opened read write
F) The uncommitted transactions are rolled back before the Instance Is shut down
Answer: AD
It performs an instance recovery before opening the database in read/write mode
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.
giovi411
5 years, 5 months agogiovi411
5 years, 5 months ago