网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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 opertion
参考答案
更多 “ 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 operationB、Because the object number changes after the flashback operationC、Because the rows are retrieved from the recycle bin during the flashback operationD、Because the table is moved forward and back to a temporary during the flashback opertion” 相关考题
考题
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. 1, 2, and 5B. 1, 3, and 4C. 2, 3, 4, and 5D. 1, 2, 3, 4, and 5
考题
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 operationB. Because the object number changes after the flashback operationC. Because the rows are retrieved from the recycle bin during the flashback operationD. Because the table is moved forward and back to a temporary during the flashback opertion
考题
You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()
A. Drop the table.B. Partition the tableC. Truncate the table.D. Add a column to the table.E. Rename a column in the table.
考题
You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table:SQL FLASHBACK TABLE sales_emp TO BEFORE DROP;What would be the outcome of the precedent statement?（）A. It retrieves the latest version of the table from the recycle binB. It retrieves the oldest version of the table from the recycle binC. It retrieves the version of the table for which undo information is availableD. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
考题
Which two statements regarding the Flashback Table feature are correct?（）A、Flashback Table can be performed on system tables.B、Flashback Table operation does not shrink the segments.C、Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.D、Flashback Table operation acquires exclusive data manipulation language (DML) locks.
考题
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 DropB、 Flashback DatabaseC、 Flashback TableD、 Flashback Version Query
考题
You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）A、Drop the table.B、Partition the tableC、Truncate the table.D、Add a column to the table.E、Rename a column in the table.
考题
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、 RESETLOGSB、 TO TIMESTAMPC、 TO BEFORE DROPD、 RENAME TOE、 TO SCN
考题
You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（） A、 Drop the table.B、 Partition the table.C、 Truncate the table.D、 Add a column to the table.E、 Rename a column in the table.
考题
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.
考题
A user performs an update on a table. Shortly after committing the transaction， they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state？（）A、 Flashback DropB、 Flashback QueryC、 Flashback Versions QueryD、 Flashback Transaction QueryE、 Flashback Table
考题
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）A、 V$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT
考题
You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； Which two statements are correct？ （）A、 The FLASHBACK TABLE statement will not be written to the alert log file.B、 The EMP table that was dropped by mistake from the database will be restored.C、 The changes made to the EMP table since the specified time will be undone.D、 The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.E、 The FLASHBACK TABLE statement will be executed within a single transaction.F、 The list of transactions that have modified the EMP table since the specified time will be displayed.
考题
You have just performed a FLASHBACK TABLE operation using the following command： flashback table employees to scn 123456； The employees table has triggers associated with it. Which of the following statements is true regarding the state of the triggers during the Flashback Table operation？（） A、 All the triggers are disabled.B、 All the triggers are enabled by default.C、 Enabled triggers remain enabled and disabled triggers remain disabled.D、 Triggers are deleted when a Flashback Table operation is performed.
考题
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： SQL FLASHBACK TABLE ORDERS TO SCN 771513； What is the prerequisite to perform Flashback Table？（）A、 You must configure OMF in your database.B、 You must enable block change tracking feature in your database.C、 You must enable ROW MOVEMENT feature on the ORDERS table.D、 You must use the Flashback Version Query before using the Flashback Table feature.
考题
单选题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 DropB
Flashback DatabaseC
Flashback TableD
Flashback Version Query
考题
单选题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.
考题
单选题Note the following statements that use flashback technology: 1. FLASHBACK TABLE TO SCN ; 2. SELECT * FROM AS OF SCN 123456; 3. FLASHBACK TABLE TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP ; 5. SELECT * FROM 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
1, 2, and 5B
1, 3, and 4C
2, 3, 4, and 5D
1, 2, 3, 4, and 5
考题
多选题You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; Which two statements are correct？（）AThe FLASHBACK TABLE statement will not be written to the alert log file.BThe changes made to the EMP table since the specified time will be undone.CThe EMP table that was dropped by mistake from the database will be restored.DThe FLASHBACK TABLE statement will be executed within a single transaction.EThe FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.FThe list of transactions that have modified the EMP table since the specified time will be displayed.
考题
单选题You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）A
Drop the table.B
Partition the tableC
Truncate the table.D
Add a column to the table.E
Rename a column in the table.
考题
单选题You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE 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 and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that： a） No other user data in the database is affected. b） The operation takes the minimum possible time. Which option would you choose？（）A
use the ROLLBACK command with SCN 663571B
perform Flashback Transaction Query with SCN 663571C
execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D
execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
考题
单选题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 tableC
Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D
Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
考题
单选题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： SQL FLASHBACK TABLE ORDERS TO SCN 771513； What is the prerequisite to perform Flashback Table？（）A
You must configure OMF in your database.B
You must enable block change tracking feature in your database.C
You must enable ROW MOVEMENT feature on the ORDERS table.D
You must use the Flashback Version Query before using the Flashback Table feature.
考题
单选题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 operationB
Because the object number changes after the flashback operationC
Because the rows are retrieved from the recycle bin during the flashback operationD
Because the table is moved forward and back to a temporary during the flashback operation
考题
单选题A user performs an update on a table. Shortly after committing the transaction， they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state？（）A
Flashback DropB
Flashback QueryC
Flashback Versions QueryD
Flashback Transaction QueryE
Flashback Table
考题
多选题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？ （）ARESETLOGSBTO TIMESTAMPCTO BEFORE DROPDRENAME TOETO SCN
考题
单选题You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE 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 and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that： a） No other user data in the database is affected. b） The operation takes the minimum possible time. Which option would you choose？（）A
Use ROLLBACK command with SCN 663571.B
Perform Flashback Transaction Query with SCN 663571.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.
考题
单选题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 operationB
Because the object number changes after the flashback operationC
Because the rows are retrieved from the recycle bin during the flashback operationD
Because the table is moved forward and back to a temporary during the flashback opertion
热门标签
最新试卷
