Before a Flashback Table operation, you execute the following command:<br /> ALTER TABLE employees ENABLE ROW MOVEMENT;<br /> Why would you need this to be executed?（）..

第1题

[多选题] Which three statements are true about Flashback Database?（）

A、Flashback logs are written sequentially, and are archived. B、Flashback Database uses a restored control file to recover a database. C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea. D、Flashback Database can recover a database to the state that it was in before a reset logs operation. E、Flashback Database can recover a data file that was dropped during the span of time of the flashback. F、Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

点击查看答案

第2题

[] Which three statements are true about Flashback Database?（）

A、A. Flashback logs are written sequentially, and are archived. B、B. Flashback Database uses a restored control file to recover a database. C、C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea. D、D. Flashback Database can recover a database to the state that it was in before a reset logs operation. E、E. Flashback Database can recover a data file that was dropped during the span of time of the flashback. F、F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

点击查看答案

第3题

[单选题] Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）

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 operation

点击查看答案

第4题

[] Note the following statements that use flashback technology: 1. FLASHBACK TABLE <table> TO SCN <scn>; 2. SELECT * FROM <table> AS OF SCN 123456; 3. FLASHBACK TABLE <table> TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>; 5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999; Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（） Note the following statements that use flashback technology: 1. FLASHBACK TABLE <table> TO SCN <scn>; 2. SELECT * FROM <table> AS OF SCN 123456; 3. FLASHBACK TABLE <table> TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>; 5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999; Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）

A、A. 1, 2, and 5 B、B. 1, 3, and 4 C、C. 2, 3, 4, and 5 D、D. 1, 2, 3, 4, and 5

点击查看答案

第5题

[单选题] You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）

A、Restore the backup control file and open the database with RESETLOGS option. B、Perform point-in-time recovery because flashback cannot be performed again on this table C、Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571 D、Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

点击查看答案

第6题

[单选题] You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）

A、Restore the backup control file and open the database with RESETLOGS option. B、Perform point-in-time recovery because flashback cannot be performed again on this table C、Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571 D、Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

点击查看答案

第7题

[多选题] Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)

A、Flash recovery area must be defined B、Undo retention guarantee must be enabled. C、Database must be running in archivelog mode. D、Automatic undo management must be enabled. E、The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

点击查看答案

第8题

[单选题] Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）

A、point-in-time recovery B、execute the ROLLBACK command with transaction number C、flashback the database to before the transaction was committed D、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

点击查看答案

第9题

[多选题] 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

点击查看答案

Before a Flashback Table operation, you execute the following command:<br /> ALTER TABLE employees ENABLE ROW MOVEMENT;<br /> Why would you need this to be executed?（）

请使用微信扫码支付