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

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

相似考题

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

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

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

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 onlyB、Flashback Table onlyC、Flashback Versions Query onlyD、Flashback Database and Flashback Transaction QueryE、Flashback Versions Query and Flashback Transaction Query

更多“单选题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 af”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）

    • A、The EMPLOYEES table will be changed to read-only mode during the shrink operation.
    • B、The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
    • C、The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
    • D、Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

    正确答案:C

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

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


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

  • 第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.


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

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

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


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

  • 第10题：

    单选题
    You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）
    A

     You must enable the row movement on the SCOTT.EMP table.

    B

     You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

    C

     You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.

    D

     You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.


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

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

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


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    单选题
    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
    解析： 暂无解析

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

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

  • 第20题：

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


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

  • 第21题：

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


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

  • 第22题：

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


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

  • 第23题：

    单选题
    You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
    A

    The EMPLOYEES table will be changed to read-only mode during the shrink operation.

    B

    The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.

    C

    The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.

    D

    Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.


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

  • 第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
    解析： 暂无解析

相关内容