网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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


参考答案

参考解析
解析: 暂无解析
更多 “单选题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 BinB  when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC when you want to restore a dropped user’s schemaD  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” 相关考题
考题 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 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 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

考题 You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.

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

考题 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 BinB、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC、when you want to restore a dropped user’s schemaD、 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

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

考题 In which scenario will you use the Flashback Version Query feature?()A、 when you want to restore a table that has been dropped from the Recycle BinB、 when you want to identify the transaction ID of the transaction that deleted some important records from a tableC、 when you want to recover the schema of a dropped userD、when you want to restore a dropped tablespace

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

考题 At 10:30 A.M., you ran a batch job by mistake, which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11:10 A.M., you stopped the batch job. Now, you want to identify the changes made to the database tables by the batch job. Which view will you query?()A、 DBA_PENDING_TRANSACTIONSB、 DBA_AUDIT_STATEMENTC、 V$FLASHBACK_DATABASE_STATSD、 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

考题 单选题In which scenario will you use the Flashback Version Query feature?()A  when you want to restore a table that has been dropped from the Recycle BinB  when you want to identify the transaction ID of the transaction that deleted some important records from a tableC  when you want to recover the schema of a dropped userD when you want to restore a dropped tablespace

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

考题 单选题On Tuesday, a junior DBA dropped an important application user account, whose schema has important tables. You are asked to recover all the objects in the schema. On investigation, you find that the user account was dropped at 11:00 a.m. and Sunday’s backup is the most recent backup.Which flashback feature would you use?()A  Flashback DropB  Flashback TableC  Flashback DatabaseD  Flashback Version QueryE  Flashback Transaction Query

考题 单选题You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()A  You must use automatic undo management in the database.B  You must configure OMF in your database.C  You must configure ASM for storing the datafiles.D  You must multiplex the online redo log file.

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

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

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

考题 单选题At 10:30 A.M., you ran a batch job by mistake, which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11:10 A.M., you stopped the batch job. Now, you want to identify the changes made to the database tables by the batch job. Which view will you query?()A  DBA_PENDING_TRANSACTIONSB  DBA_AUDIT_STATEMENTC  V$FLASHBACK_DATABASE_STATSD  FLASHBACK_TRANSACTION_QUERY

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

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