Oracle10gOCP042题库130题共168题

原 Oracle 10g OCP 042 题库 1-30 题 共168题https://blog.csdn.net/tianlesoftware/article/details/5767606版权声明： https://blog.csdn.net/tianlesoftware/article/details/5767606
声明：对于答案的相关的说明，是个人对Oracle的理解。
1. Because of a power outage,instance failure has occurred. From what point in the redo log does recovery begin and where does it end?
A. Current redo log and inactive redo log
B. Checkpoint position to end of redo log
C. Beginning of redo log to end of redo log
D. All redo logs before the point of last commit
E. Beginning of redo log to checkpoint position.
答案B.  Checkpoint 之前的数据已经写入到数据文件。 所以用restore 就可以恢复。 而checkpoint之后的数据没有写入到数据文件，所以需要进行recovery。 Recovery时，对于已经commit的数据，前滚写入到数据文件。 没有commit的数据，进行回滚。
2. Which two operations can be flashed back using the flashback technology? (choose two)
A. Drop user smith;
B. Drop table employees;
C. Drop tablespace users;
D. Alter ta

最后

以上就是单身酸奶最近收集整理的关于Oracle10gOCP042题库130题共168题的全部内容，更多相关Oracle10gOCP042题库130题共168题内容请搜索靠谱客的其他文章。