CMS专题
单选题You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table： SQ
题目
You must configure OMF in your database.
You must enable block change tracking feature in your database.
You must enable ROW MOVEMENT feature on the ORDERS table.
You must use the Flashback Version Query before using the Flashback Table feature.
相似问题和答案
第1题：
By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） a list of changes made along with the transaction identifier of each change b） the necessary SQL statements to undo the erroneous changes Which option would you choose？（）
- A、RMAN only
- B、Flashback Table only
- C、Flashback Versions Query only
- D、Flashback Database and Flashback Transaction Query
- E、Flashback Versions Query and Flashback Transaction Query
正确答案:E
第2题：
On Jan 11， 2005 at 2：30 P.M.， an erroneous update operation modified all the values of column LASTNAME in the EMPLOYEE table in the Scott schema to an empty string. You are the system administrator， and you want to return the original values in the table. To do so， you decided to flash back the table. Which two options can you use to flash back a table？（）
- A、 by using Oracle Enterprise Manager
- B、 by issuing the FLASHBACK TABLE statement at the RMAN prompt
- C、 by issuing the FLASHBACK TABLE statement at the SQL prompt
- D、 by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt
正确答案:A,C
第3题：
A. Because row IDs may change during the flashback operation
B. Because the object number changes after the flashback operation
C. Because the rows are retrieved from the recycle bin during the flashback operation
D. Because the table is moved forward and back to a temporary during the flashback opertion
第4题：
By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） A list of changes made along with the transaction identifier of each change. b） The necessary SQL statements to undo the erroneous changes. Which option would you choose？（）
- A、 RMAN only.
- B、 Flashback Table only.
- C、 Flashback Version Query only.
- D、 Flashback Database and Flashback Transaction Query.
- E、 Flashback Version Query and Flashback Transaction Query.
正确答案:E
第5题：
You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about theeffect of the command（）
- A、No flashback is possible to bring back the ITEM table.
- B、The ORDERS table is dropped along with the ITEM table.
- C、The dependent referential integrity constraints in the ORDERS table are disabled.
- D、The dependent referential integrity constraints in the ORDERS table are removed.
- E、The table definition of the ITEM table and associated indexes are placed in the recycle bin
正确答案:A,D
第6题：
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？ （）
- A、 RESETLOGS
- B、 TO TIMESTAMP
- C、 TO BEFORE DROP
- D、 RENAME TO
- E、 TO SCN
正确答案:B,E
第7题：
You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（）
- A、 Flashback Table
- B、 Flashback Query
- C、Flashback Version Query
- D、 Flashback Transaction Query
正确答案:B
第8题：
At the end of the financial year， an accounts accumulation batch is run. This batch updates the company’s accounting records. During the batch run process， some incorrect entries were inserted into the ACCOUNT table. You identified the bug and immediately stopped the batch run process， but 3000 incorrect records were inserted into the ACCOUNT table before the batch process was stopped. You want to recover the table to the state it was at 11：50 P.M. Which flashback feature will you use？（）
- A、 Flashback Drop
- B、 Flashback Database
- C、 Flashback Table
- D、 Flashback Version Query
正确答案:C
第9题：
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQL>CREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）
- A、disabling the index
- B、making the index invisible
- C、making the index unusable
- D、using the MONITORING USAGE clause for the index
正确答案:B
第10题：
Which of the following statements is true regarding implementing a Flashback Table recovery？ （）
- A、 An SCN is never used to perform a Flashback Table recovery.
- B、 If a significant number of changes have been made to the table， row movement must be enabled.
- C、 The tablespace must be offline before performing a Flashback Table recovery.
- D、 Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.
正确答案:D