网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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 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 EMP table that was dropped by mistake from the database will be restored.CThe changes made to the EMP table since the specified time will be undone.DThe FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.EThe FLASHBACK TABLE statement will be executed within a single transaction.FThe list of transactions that have modified the EMP table since the specified time will be displayed.” 相关考题
考题
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 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.
考题
You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）A、 Only the Flashback TableB、 Both the Flashback Transaction Query and the Flashback Version QueryC、 Only the Flashback DropD、 Only the Flashback Version
考题
On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）A、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.B、 You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.C、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.D、 You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
考题
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 changes made to the EMP table since the specified time will be undone.C、The EMP table that was dropped by mistake from the database will be restored.D、The FLASHBACK TABLE statement will be executed within a single transaction.E、The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table. F、The list of transactions that have modified the EMP table since the specified time will be displayed.
考题
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
考题
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 ManagerB、 by issuing the FLASHBACK TABLE statement at the RMAN promptC、 by issuing the FLASHBACK TABLE statement at the SQL promptD、 by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt
考题
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 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 working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）A、perform point-in-time recoveryB、perform a Flashback Table operation to restore the table to the state it was in two days agoC、perform a Flashback Database operation to restore the database to the state it was in two days agoD、perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
考题
Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； A、to undo the changes made to the EMP table since the specified timeB、to restore the EMP table that was wrongly dropped from the databaseC、to view the transactions that have modified the EMP table since the specified timeD、to view the changes made to the EMP table for one or more rows since the specified timeE、to recover the EMP table to a point in time in the past by restoring the most recent backup
考题
In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；A、 when the schema of the user， SCOTT， was deleted by mistake 15 minutes agoB、 when the table EMP of the SCOTT schema was dropped by mistake 15 minutes agoC、 when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes agoD、 when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutesE、 never， because FLASHBACK TABLE is not a valid command in Oracle 10g.
考题
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
考题
Note the output of the following query； SQL SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1 You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table： ALTER TABLE exchange_rate FLASHBACK ARCHIEVE； What is the outcome of this command？（） A、 The table uses the default Flashback Data Archive.B、 The Flashback Data Archive Is created In the SYSAUX tablespace.C、 The Flashback Data Archive is created in the same tablespace where the tables are stored.D、 The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.
考题
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.
考题
单选题Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’.’hh12：mi’）；A
to undo the changes made to the EMP table since the specified timeB
to restore the EMP table that was wrongly dropped from the databaseC
to view the transactions that have modified the EMP table since the specified timeD
to view the changes made to the EMP table for one or more rows since the specified time
考题
单选题Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）;A
to undo the changes made to the EMP table since the specified timeB
to restore the EMP table that was wrongly dropped from the databaseC
to view the transactions that have modified the EMP table since the specified timeD
to view the changes made to the EMP table for one or more rows since the specified timeE
to recover the EMP table to a point in time in the past by restoring the most recent backup
考题
多选题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 EMP table that was dropped by mistake from the database will be restored.CThe changes made to the EMP table since the specified time will be undone.DThe FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.EThe FLASHBACK TABLE statement will be executed within a single transaction.FThe 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 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
考题
多选题In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；Awhen the schema of the user， SCOTT， was deleted by mistake 15 minutes agoBwhen the table EMP of the SCOTT schema was dropped by mistake 15 minutes agoCwhen some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes agoDwhen some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutesEnever， because FLASHBACK TABLE is not a valid command in Oracle 10g.
考题
多选题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？（）Aby using Oracle Enterprise ManagerBby issuing the FLASHBACK TABLE statement at the RMAN promptCby issuing the FLASHBACK TABLE statement at the SQL promptDby issuing the FLASHBACK TABLE statement at the LSNRCTL prompt
考题
多选题For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）AUPDATE TABLEBCREATE CLUSTERCTRUNCATE TABLEDALTER TABLE MOVEEINSERT INTO···VALUESFALTER TABLE···DROP COLUMNGALTER TABLE···DROP PARTITION
考题
单选题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
热门标签
最新试卷