多选题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 mi

题目
多选题
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.

相似考题

1.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

2.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

3.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.

4.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 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 mi”相关问题

  • 第1题：

    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 Table
    • B、 Both the Flashback Transaction Query and the Flashback Version Query
    • C、 Only the Flashback Drop
    • D、 Only the Flashback Version

    正确答案:B

  • 第2题：

    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.

    正确答案:B,D

  • 第3题：

    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

  • 第4题：

    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

    正确答案:D

  • 第5题：

    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 time
    • B、to restore the EMP table that was wrongly dropped from the database
    • C、to view the transactions that have modified the EMP table since the specified time
    • D、to view the changes made to the EMP table for one or more rows since the specified time
    • E、to recover the EMP table to a point in time in the past by restoring the most recent backup

    正确答案:A

  • 第6题：

    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 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

    正确答案:D

  • 第7题：

    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.

    正确答案:A

  • 第8题：

    单选题
    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 time

    B

     to restore the EMP table that was wrongly dropped from the database

    C

     to view the transactions that have modified the EMP table since the specified time

    D

     to view the changes made to the EMP table for one or more rows since the specified time


    正确答案： D
    解析： 暂无解析

  • 第9题：

    多选题
    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.


    正确答案： D,B
    解析： 暂无解析

  • 第10题：

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


    正确答案： C,D
    解析： 暂无解析

  • 第11题：

    多选题
    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,B
    解析： 暂无解析

  • 第12题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:B

  • 第14题：

    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

  • 第15题：

    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

    正确答案:A

  • 第16题：

    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 recovery
    • B、perform a Flashback Table operation to restore the table to the state it was in two days ago
    • C、perform a Flashback Database operation to restore the database to the state it was in two days ago
    • D、perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery

    正确答案:D

  • 第17题：

    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 ago
    • B、 when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago
    • C、 when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago
    • D、 when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes
    • E、 never， because FLASHBACK TABLE is not a valid command in Oracle 10g.

    正确答案:C,D

  • 第18题：

    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.

    正确答案:A

  • 第19题：

    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.

    正确答案:C

  • 第20题：

    单选题
    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 time

    B

    to restore the EMP table that was wrongly dropped from the database

    C

    to view the transactions that have modified the EMP table since the specified time

    D

    to view the changes made to the EMP table for one or more rows since the specified time

    E

    to recover the EMP table to a point in time in the past by restoring the most recent backup


    正确答案： E
    解析： 暂无解析

  • 第21题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第22题：

    多选题
    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 ago

    B

    when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago

    C

    when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago

    D

    when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes

    E

    never， because FLASHBACK TABLE is not a valid command in Oracle 10g.


    正确答案： B,C
    解析： 暂无解析

  • 第23题：

    多选题
    For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）
    A

    UPDATE TABLE

    B

    CREATE CLUSTER

    C

    TRUNCATE TABLE

    D

    ALTER TABLE MOVE

    E

    INSERT INTO···VALUES

    F

    ALTER TABLE···DROP COLUMN

    G

    ALTER TABLE···DROP PARTITION


    正确答案： C,B
    解析： 暂无解析

  • 第24题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

相关内容