CMS专题
单选题ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation（）A The online redo lo
题目
The online redo log files and archived redo log files are required to accomplish the recovery.
The uncommitted transaction will be committed at the next startup of the database instance.
The uncommitted transaction is rolled back automatically at the next opening of the database.
The DBA has to perform the recovery on the database to recover the uncommitted transaction.
相似问题和答案
第1题：
开始事务，提交事务，回滚事务的英语单词分别是：
A.begin transaction , rollback transaction , commit transaction
B.commit transaction , rollback transaction , begin transaction
C.rollback transaction , begin transaction , commit transaction
D.begin transaction , commit transaction , rollback transaction
第2题：
The technological advances made it possible for the middle classes to enjoy what had once been()only to the very rich.
A. manageable
B. measurable
C. affordable
第3题：
A.make for
B.make up for
C.make up
D.make ou
第4题：
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）
- A、The online redo log files and archived redo log files are required to accomplish the recovery.
- B、The uncommitted transaction will be committed at the next startup of the database instance.
- C、The uncommitted transaction is rolled back automatically at the next opening of the database.
- D、The DBA has to perform the recovery on the database to recover the uncommitted transaction
正确答案:C
第5题：
You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）
- A、On startup， SMON coordinates instance recovery.
- B、On startup， CKPT coordinates instance recovery.
- C、On startup， use RMAN to perform instance recovery.
- D、Uncommitted changes will be rolled back after the database is opened.
- E、On startup， perform media recovery and then instance recovery.
- F、On startup， all the files will be synchronized and you get both committed and uncommitted data.
正确答案:A,D
第6题：
People of ancient Egypt and Europeans of the Middle Ages ______.
A. both worshipped black cats
B. both feared black cats
C. thought black cats could bring good luck
D. felt very different about black cats
第7题：
The two industries embody both import and export () a single transaction. The purpose of importation is to create exportation.
A、in
B、at
C、for
D、of
第8题：
A.It is going to rain pretty soon
B.Y ou look very beautiful
C.The red dress fits me very much
第9题：
When installing a server in a rack， which of the following locations describes where in the rack a server should be installed？（）
- A、On the very bottom U of the rack， with the UPS above the server
- B、In the middle of the rack to help balance the rack
- C、Closest to the bottom of the rack， above heavier equipment
- D、On the very top U of the rack， with the UPS directly below it
正确答案:C
第10题：
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）
- A、uses undo data for roll forward
- B、uses Flashback Log for recovery
- C、uses online redo logs to roll back
- D、uses undo data to roll back the transaction
- E、uses Recovery Manager （RMAN） to roll back
- F、uses the System Monitor （SMON） background process to perform instance recovery
正确答案:D