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 

题目

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_STARTSCN
  • B、 VERSIONS_STARTTIME
  • C、 VERSIONS_XID
  • D、 VERSIONS_OPERATION
相似考题

1.On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC. Query the V$RECOVERY_FILE_DEST_SIZE viewD.Query the V$FLASHBACK_DATABASE_STAT viewE. Check the value assigned for the UNDO_RETENTION parameter

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

3.You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）  A、 The database will not start.B、 The database will start but will not retain the undo data in the undo segment.C、 The database will start， and the undo segment will contain the undo data for at least one hour.D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.

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

  • 第1题：

    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

    正确答案:E

  • 第2题：

    On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）

    • A、Check the alert log file
    • B、Query the V$FLASHBACK_DATABASE_LOG view
    • C、Query the V$RECOVERY_FILE_DEST_SIZE view
    • D、Query the V$FLASHBACK_DATABASE_STAT view
    • E、Check the value assigned for the UNDO_RETENTION parameter

    正确答案:B

  • 第3题：

    You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）  

    • A、the value of the UNDO_RETENTION initialization parameter
    • B、the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
    • C、the online redo log files size
    • D、the number of redo log members in a group

    正确答案:C

  • 第4题：

    You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

    • A、 To recover a dropped table.
    • B、 To recover a dropped schema.
    • C、 To recover data from a truncated table.
    • D、 To view changes made by all the transactions during a given period of time.
    • E、 To view changes made by a single transaction during a given period of time.

    正确答案:D,E

  • 第5题：

    You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

    • A、 by using the Flashback Database feature
    • B、 by using RMAN incomplete recovery
    • C、 by performing a user-managed incomplete recovery
    • D、 by dropping and re-creating the index tablespace

    正确答案:D

  • 第6题：

    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

  • 第7题：

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

    B

     DBA_AUDIT_STATEMENT

    C

     V$FLASHBACK_DATABASE_STATS

    D

     FLASHBACK_TRANSACTION_QUERY


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

  • 第8题：

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

  • 第9题：

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

  • 第10题：

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


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

  • 第11题：

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

  • 第12题：

    多选题
    You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）
    A

    To recover a dropped table.

    B

    To recover a dropped schema.

    C

    To recover data from a truncated table.

    D

    To view changes made by all the transactions during a given period of time.

    E

    To view changes made by a single transaction during a given period of time.


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

  • 第13题：

    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

  • 第14题：

    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

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

    正确答案:D

  • 第17题：

    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

  • 第18题：

    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_TRANSACTIONS
    • B、 DBA_AUDIT_STATEMENT
    • C、 V$FLASHBACK_DATABASE_STATS
    • D、 FLASHBACK_TRANSACTION_QUERY

    正确答案:D

  • 第19题：

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


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

  • 第20题：

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

    B

     VERSIONS_STARTTIME

    C

     VERSIONS_XID

    D

     VERSIONS_OPERATION


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

  • 第21题：

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


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

  • 第22题：

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

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

相关内容