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

题目

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 Drop
  • B、 Flashback Query
  • C、 Flashback Versions Query
  • D、 Flashback Transaction Query
  • E、 Flashback Table
相似考题

1.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 recoveryB. execute the ROLLBACK command with transaction numberC. flashback the database to before the transaction was committedD. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

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

3. At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion：    SELECT operation， undo_sql， logon_user   FROM FLASHBACK_TRANSACTION_QUERY  WHERE xid=   HEXTORAW（’0100043E23456’）；   where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）A、 William used the Flashback Version Query feature.B、 William issued the CROSSCHECK command at the RMAN prompt.C、 William viewed the alert log file.D、 William used the Flashback Table feature.

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

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

  • 第1题：

    Users notify you that their application is failing every time they try to add new records. Because of poor application design， the actual ORA error message is unavailable.  What might be the problem？（）

    • A、 The application user has exceeded their undo quota.
    • B、 The FLASHBACK GUARANTEE option is set on the undo tablespace.
    • C、 The table is currently being queried by a Flashback Transaction Query operation.
    • D、 The table is currently being queried by a Flashback Versions Query operation.
    • E、 The RETENTION GUARANTEE option is set on the undo tablespace.

    正确答案:A,E

  • 第2题：

    In which scenario will you use the Flashback Transaction Query feature？（）

    • A、 when you want to restore an important table that is dropped from the Recycle Bin
    • B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
    • C、when you want to restore a dropped user’s schema
    • D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

    正确答案:B

  • 第3题：

    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

    正确答案:D

  • 第4题：

    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

  • 第5题：

    You work as a database administrator at Certkiller .com. 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 EMPLOYEEStable. 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

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

    正确答案:D

  • 第7题：

    多选题
    The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened byuser JIM has a transaction that caused the deadlock.  Which two statements are true regarding the session ofSCOTT in this scenario（）
    A

    The session is terminated after receiving the error and JIM can continue with his transaction.

    B

    SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

    C

    The session is rolled back after receiving the error and JIM can continue with his transaction.

    D

    SCOTT has to reexecute the last command in the transaction after he commits the transaction.


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

  • 第8题：

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


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

  • 第9题：

    多选题
    Users notify you that their application is failing every time they try to add new records. Because of poor application design， the actual ORA error message is unavailable.  What might be the problem？（）
    A

    The application user has exceeded their undo quota.

    B

    The FLASHBACK GUARANTEE option is set on the undo tablespace.

    C

    The table is currently being queried by a Flashback Transaction Query operation.

    D

    The table is currently being queried by a Flashback Versions Query operation.

    E

    The RETENTION GUARANTEE option is set on the undo tablespace.


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

  • 第10题：

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


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

  • 第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题：

    多选题
    You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）
    A

    The batch operation started by the user， SCOTT， terminates with an error.

    B

    The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.

    C

    The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.

    D

    The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.

    E

    The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.


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

  • 第13题：

    The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table：  ERROR at line 1：  ORA-00060： deadlock detected while waiting for resource  On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock.  two statements are true regarding the session of SCOTT in this scenario（）

    • A、The session is terminated after receiving the error and JIM can continue with his transaction.
    • B、SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
    • C、The session is rolled back after receiving the error and JIM can continue with his transaction.
    • D、SCOTT has to reexecute the last command in the transaction after he commits the transaction.

    正确答案:B,D

  • 第14题：

    View the following SQL statements：   Transaction T1 INSERT INTO hr.regions VALUES （5，’Pole’）；COMMIT；  Transaction T2 UPDATE hr.regions SET region_name=’Poles’ WHERE region_id = 5； COMMIT；  Transaction T3 UPDATE hr.regions SET region_name=’North and South Poles’ WHERE region_id = 5；   You want to back out transaction T2.  Which option would you use？（）

    • A、 It is possible，but transaction T3 also backs out.
    • B、 It is possible with the NOCASCADE_FORCE option.
    • C、 It is possible with the NONCONFLICT_ONLY option.
    • D、 It is not possible because it has conflicts with transaction T3.

    正确答案:B

  • 第15题：

    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

  • 第16题：

    You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）

    • A、 The batch operation started by the user， SCOTT， terminates with an error.
    • B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.
    • C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
    • D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
    • E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.

    正确答案:A,D

  • 第17题：

    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

  • 第18题：

    单选题
    You work as a database administrator at Certkiller .com. 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 EMPLOYEEStable. 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


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

  • 第19题：

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

    B

     Flashback Query

    C

     Flashback Versions Query

    D

     Flashback Transaction Query

    E

     Flashback Table


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

  • 第20题：

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


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

  • 第21题：

    单选题
    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 Versions Query only

    D

    Flashback Database and Flashback Transaction Query

    E

    Flashback Versions Query and Flashback Transaction Query


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

  • 第22题：

    单选题
    A user named Arren is executing this query：   select table_name，operation，undo_sql  from  flashback_transaction_query t，  （select versions_xid as xid  from employees versions between scn minvalue and maxvalue  where employee_id = 123） e  where t.xid = e.xid；   When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem.  Which of the following SQL statements will correct this problem？（）
    A

     GRANT SELECT ANY TRANSACTION TO ARREN

    B

     GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN

    C

     GRANT SELECT_ANY_TRANSACTION TO ARREN

    D

     GRANT FLASHBACK TO ARREN

    E

     GRANT SELECT ANY VIEW TO ARREN


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

  • 第23题：

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

相关内容