Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？（）

Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）

单选题查看答案

Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository？（） 

多选题查看答案

The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）

单选题查看答案

You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）

单选题查看答案

Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？ （）

单选题查看答案

You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？ （）

多选题查看答案

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？（）

多选题查看答案

You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）

单选题查看答案

Which of the following are not fundamental tasks of the Support Workbench？（）

多选题查看答案