单选题By using the transaction identifier provided by （） for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction.AFlashback TableBFlashback DatabaseCFlashback Versions QueryDthe RMAN REPORT commandEthe DBA_PENDING_TRANSACTIONS view
单选题
By using the transaction identifier provided by （） for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction.
A
Flashback Table
B
Flashback Database
C
Flashback Versions Query
D
the RMAN REPORT command
E
the DBA_PENDING_TRANSACTIONS view
参考解析
解析：
暂无解析
相关考题：
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
By using the transaction identifier provided by（）for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction. A、 Flashback TableB、 Flashback DatabaseC、 Flashback Version QueryD、 The RMAN REPORT commandE、 The DBA_PENDING_TRANSACTIONS view
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
You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）A、 VERSIONS_STARTSCNB、 VERSIONS_STARTTIMEC、 VERSIONS_XIDD、 VERSIONS_OPERATION
Over the course of a day，a department performed multiple DML statements （inserts， updates， deletes） on multiple rows of data in multiple tables. The manager would like a report showing the time， table name，and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list？（）A、 Flashback DropB、 Flashback QueryC、 Flashback Transaction QueryD、 Flashback Versions QueryE、 Flashback Table
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
You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（） A、 Flashback TableB、 Flashback QueryC、Flashback Version QueryD、 Flashback Transaction Query
By using the transaction identifier provided by （） for a particular row change， you can use theFlashback Transaction Query to see the operation performed by the transaction. A、Flashback TableB、Flashback DatabaseC、Flashback Versions QueryD、the RMAN REPORT commandE、the DBA_PENDING_TRANSACTIONS view
You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）A、 The time when the last flashback operation in your database was performed.B、 The time when the first flashback operation in your database was performed.C、 A list of flashback operations performed in your database using SCN and time.D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.
You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number （SCN） to which you can flash back your database
By using the transaction identifier provided by （） for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction. A、Flashback TableB、Flashback DatabaseC、Flashback Versions QueryD、the RMAN REPORT commandE、the DBA_PENDING_TRANSACTIONS view
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 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
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.
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
单选题By using the transaction identifier provided by（）for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction.A Flashback TableB Flashback DatabaseC Flashback Version QueryD The RMAN REPORT commandE The DBA_PENDING_TRANSACTIONS view
单选题You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）A VERSIONS_STARTSCNB VERSIONS_STARTTIMEC VERSIONS_XIDD VERSIONS_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 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
单选题You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（）A Flashback TableB Flashback QueryCFlashback Version QueryD Flashback Transaction Query
单选题You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）Athe time when the last flashback operation in your database was performedBthe time when the first flashback operation in your database was performedCa list of flashback operations performed in your database using SCN and timeDthe approximate time and the lowest system change number （SCN） to which you can flash back your database
单选题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？（）ARMAN onlyBFlashback Table onlyCFlashback Versions Query onlyDFlashback Database and Flashback Transaction QueryEFlashback Versions Query and Flashback Transaction Query
单选题By using the transaction identifier provided by （） for a particular row change， you can use theFlashback Transaction Query to see the operation performed by the transaction.AFlashback TableBFlashback DatabaseCFlashback Versions QueryDthe RMAN REPORT commandEthe DBA_PENDING_TRANSACTIONS view
单选题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
单选题Over the course of a day，a department performed multiple DML statements （inserts， updates， deletes） on multiple rows of data in multiple tables. The manager would like a report showing the time， table name，and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list？（）A Flashback DropB Flashback QueryC Flashback Transaction QueryD Flashback Versions QueryE Flashback Table
单选题You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）A The time when the last flashback operation in your database was performed.B The time when the first flashback operation in your database was performed.C A list of flashback operations performed in your database using SCN and time.D The approximate time and the lowest system change number （SCN） to which you can flash back your database.
单选题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？（）Aperform point-in-time recoveryBperform a Flashback Table operation to restore the table to the state it was in two days agoCperform a Flashback Database operation to restore the database to the state it was in two days agoDperform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
单选题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.