多选题You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）ATo recover a dropped table.BTo recover a dropped schema.CTo recover data from a truncated table.DTo view changes made by al

题目
多选题
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.

相似考题

1.The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?()A. All the related indexes and views are automatically droppedB. The flashback drop feature can recover only the table structureC. Only the related indexes are dropped whereas views are invalidatedD. The flashback drop feature can recover both the table structure and its data

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

3. The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)A、All the related indexes and views are automatically droppedB、The flashback drop feature can recover only the table structureC、Only the related indexes are dropped whereas views are invalidatedD、The flashback drop feature can recover both the table structure and its data

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 working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）ATo recover a dropped table.BTo recover a dropped schema.CTo recover data from a truncated table.DTo view changes made by al”相关问题

  • 第1题：

    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

  • 第2题：

    In which case would you use the Flashback Database feature to perform a recovery？（）

    • A、to recover a dropped tablespace
    • B、to recover data from a truncated table
    • C、to recover a data file that has been shrunk
    • D、to recover a database to the state that existed before the RESETLOGS operation

    正确答案:B

  • 第3题：

    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

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

    You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

    • A、 UNTIL SEQUENCE
    • B、 UNTIL SCN
    • C、 UNTIL CHANGE
    • D、 UNTIL CANCEL

    正确答案:C,D

  • 第6题：

    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

  • 第7题：

    多选题
    The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)
    A

    All the related indexes and views are automatically dropped

    B

    The flashback drop feature can recover only the table structure

    C

    Only the related indexes are dropped whereas views are invalidated

    D

    The flashback drop feature can recover both the table structure and its data


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

  • 第8题：

    单选题
    Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）;
    A

    to undo the changes made to the EMP table since the specified time

    B

    to restore the EMP table that was wrongly dropped from the database

    C

    to view the transactions that have modified the EMP table since the specified time

    D

    to view the changes made to the EMP table for one or more rows since the specified time

    E

    to recover the EMP table to a point in time in the past by restoring the most recent backup


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

  • 第9题：

    多选题
    You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）
    A

    UNTIL SEQUENCE

    B

    UNTIL SCN

    C

    UNTIL CHANGE

    D

    UNTIL CANCEL


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

  • 第10题：

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

  • 第11题：

    单选题
    In which case would you use the Flashback Database feature to perform a recovery？（）
    A

    to recover a dropped tablespace

    B

    to recover data from a truncated table

    C

    to recover a data file that has been shrunk

    D

    to recover a database to the state that existed before the RESETLOGS operation


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

  • 第12题：

    多选题
    The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）
    A

    All the related indexes and views are automatically dropped

    B

    The flashback drop feature can recover only the table structure

    C

    Only the related indexes are dropped whereas views are invalidated

    D

    The flashback drop feature can recover both the table structure and its data


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

  • 第13题：

    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

  • 第14题：

    Why would you use the following FLASHBACK TABLE command？（）  FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； 

    • A、to undo the changes made to the EMP table since the specified time
    • B、to restore the EMP table that was wrongly dropped from the database
    • C、to view the transactions that have modified the EMP table since the specified time
    • D、to view the changes made to the EMP table for one or more rows since the specified time
    • E、to recover the EMP table to a point in time in the past by restoring the most recent backup

    正确答案:A

  • 第15题：

    The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）

    • A、 All the related indexes and views are automatically dropped
    • B、 The flashback drop feature can recover only the table structure
    • C、 Only the related indexes are dropped whereas views are invalidated
    • D、 The flashback drop feature can recover both the table structure and its data

    正确答案:C,D

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

    Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

    • A、 V$DATABASE
    • B、 V$UNDOSTAT
    • C、 V$FLASHBACK_DATABASE_LOG
    • D、 V$FLASHBACK_DATABASE_STAT

    正确答案:C

  • 第18题：

    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

  • 第19题：

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

  • 第20题：

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

  • 第21题：

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

  • 第22题：

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

  • 第23题：

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


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

  • 第24题：

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

相关内容