单选题In which scenario will you use the Flashback Version Query feature？（）Awhen you want to restore a table that has been dropped from the Recycle BinBwhen you want to identify the transaction ID of the transaction that deleted some important records from a

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

B

 when you want to identify the transaction ID of the transaction that deleted some important records from a table

C

 when you want to recover the schema of a dropped user

D

when you want to restore a dropped tablespace

相似考题

1.You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table:SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP;What would be the outcome of the precedent statement?（）A. It retrieves the latest version of the table from the recycle binB. It retrieves the oldest version of the table from the recycle binC. It retrieves the version of the table for which undo information is availableD. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

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.On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）A、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.B、 You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.C、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.D、 You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

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

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

  • 第1题：

    At the end of the financial year， an accounts accumulation batch is run. This batch updates the company’s accounting records. During the batch run process， some incorrect entries were inserted into the ACCOUNT table. You identified the bug and immediately stopped the batch run process， but 3000 incorrect records were inserted into the ACCOUNT table before the batch process was stopped. You want to recover the table to the state it was at 11：50 P.M. Which flashback feature will you use？（）

    • A、 Flashback Drop
    • B、 Flashback Database
    • C、 Flashback Table
    • D、 Flashback Version Query

    正确答案:C

  • 第2题：

    In which scenario do you use the Flashback Database feature？（）

    • A、 when a table is dropped and you restore it from the Recycle Bin
    • B、 when a user’s schema is dropped and you recover the user’s schema
    • C、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
    • D、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration

    正确答案:B

  • 第3题：

    In which scenario will you perform a user-managed incomplete recovery？（）

    • A、 when a table is dropped and stored in the Recycle Bin
    • B、when a table is dropped and purged from the Recycle Bin
    • C、 when you are required to recover an existing table to its previous state
    • D、 when you are required to view all the versions of a row of an existing table between a specific time period

    正确答案:B

  • 第4题：

    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 Drop
    • B、Flashback Table
    • C、Flashback Database
    • D、Flashback Version Query
    • E、Flashback Transaction Query

    正确答案:C

  • 第5题：

    In which scenario will you perform an incomplete recovery？（）

    • A、 when a table is dropped and stored in the Recycle Bin
    • B、 when all the control files are deleted
    • C、 when a member of a multiplexed redo log group is dropped
    • D、 when you are required to recover a table to its previous state

    正确答案:B

  • 第6题：

    You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）

    • A、 use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
    • B、 restore the entire database from the most recent backup and open it
    • C、 recover the table by using the Flashback Table feature
    • D、 perform point-in-time recovery to recover the table

    正确答案:D

  • 第7题：

    单选题
    In which scenario do you use the Flashback Database feature？（）
    A

     when a table is dropped and you restore it from the Recycle Bin

    B

     when a user’s schema is dropped and you recover the user’s schema

    C

     when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp

    D

     when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration


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

  • 第8题：

    单选题
    You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）
    A

     use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table

    B

     restore the entire database from the most recent backup and open it

    C

     recover the table by using the Flashback Table feature

    D

     perform point-in-time recovery to recover the table


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

  • 第9题：

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

  • 第10题：

    单选题
    In which scenario will you perform a user-managed incomplete recovery？（）
    A

     when a table is dropped and stored in the Recycle Bin

    B

    when a table is dropped and purged from the Recycle Bin

    C

     when you are required to recover an existing table to its previous state

    D

     when you are required to view all the versions of a row of an existing table between a specific time period


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

  • 第11题：

    单选题
    At the end of the financial year， an accounts accumulation batch is run. This batch updates the company’s accounting records. During the batch run process， some incorrect entries were inserted into the ACCOUNT table. You identified the bug and immediately stopped the batch run process， but 3000 incorrect records were inserted into the ACCOUNT table before the batch process was stopped. You want to recover the table to the state it was at 11：50 P.M. Which flashback feature will you use？（）
    A

     Flashback Drop

    B

     Flashback Database

    C

     Flashback Table

    D

     Flashback Version Query


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

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

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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 Bin
    • B、 when you want to identify the transaction ID of the transaction that deleted some important records from a table
    • C、 when you want to recover the schema of a dropped user
    • D、when you want to restore a dropped tablespace

    正确答案:B

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

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

  • 第19题：

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

    B

     Flashback Table

    C

     Flashback Database

    D

     Flashback Version Query

    E

     Flashback Transaction Query


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

  • 第20题：

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

  • 第21题：

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

    B

    Flashback Table

    C

    Flashback Database

    D

    Flashback Version Query

    E

    Flashback Transaction Query


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

  • 第22题：

    单选题
    On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）
    A

     You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.

    B

     You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.

    C

     You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.

    D

     You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.


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

  • 第23题：

    单选题
    In which scenario will you perform an incomplete recovery？（）
    A

     when a table is dropped and stored in the Recycle Bin

    B

     when all the control files are deleted

    C

     when a member of a multiplexed redo log group is dropped

    D

     when you are required to recover a table to its previous state


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

相关内容