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 

题目

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

1.You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）A、 Flashback logs are not archived.B、 Flashback logs are maintained in redo log files.C、 Flashback logs are maintained in the Flash Recovery Area.D、 Flashback logs are used to maintain Flashback Database related errors.E、 Flashback logs need to be cleared manually after you disable Flashback Database.

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

3.On Jan 11， 2005 at 2：30 P.M.， an erroneous update operation modified all the values of column LASTNAME in the EMPLOYEE table in the Scott schema to an empty string. You are the system administrator， and you want to return the original values in the table. To do so， you decided to flash back the table. Which two options can you use to flash back a table？（）A、 by using Oracle Enterprise ManagerB、 by issuing the FLASHBACK TABLE statement at the RMAN promptC、 by issuing the FLASHBACK TABLE statement at the SQL promptD、 by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt

4. Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）A、 The database does not record flashback logs for MY_TABLESPACEB、 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.C、 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.D、 None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

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

  • 第1题：

    You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs？（）

    • A、 LGWR
    • B、 DBWR
    • C、 MMON
    • D、 RVWR

    正确答案:D

  • 第2题：

    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.

    正确答案:D

  • 第3题：

    You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader directpath load method to perform this task. The table in which you plan to load data is an important tablehaving various integrity constraints defined on it.  Which constraints will remain enabled by default during this operation（）

    • A、CHECK
    • B、UNIQUE
    • C、NOT NULL
    • D、PRIMARY KEY
    • E、FOREIGN KEY

    正确答案:B,C,D

  • 第4题：

    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

  • 第5题：

    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

    • A、 incomplete recovery
    • B、 complete recovery
    • C、 recovery using the Flashback Database feature
    • D、 recovery using the export/import utility

    正确答案:A

  • 第6题：

    You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table：  SQL> FLASHBACK TABLE ORDERS TO SCN 771513；   What is the prerequisite to perform Flashback Table？（）

    • A、 You must configure OMF in your database.
    • B、 You must enable block change tracking feature in your database.
    • C、 You must enable ROW MOVEMENT feature on the ORDERS table.
    • D、 You must use the Flashback Version Query before using the Flashback Table feature.

    正确答案:C

  • 第7题：

    单选题
    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）
    A

     incomplete recovery

    B

     complete recovery

    C

     recovery using the Flashback Database feature

    D

     recovery using the export/import utility


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

  • 第8题：

    多选题
    On Jan 11， 2005 at 2：30 P.M.， an erroneous update operation modified all the values of column LASTNAME in the EMPLOYEE table in the Scott schema to an empty string. You are the system administrator， and you want to return the original values in the table. To do so， you decided to flash back the table. Which two options can you use to flash back a table？（）
    A

    by using Oracle Enterprise Manager

    B

    by issuing the FLASHBACK TABLE statement at the RMAN prompt

    C

    by issuing the FLASHBACK TABLE statement at the SQL prompt

    D

    by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt


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

  • 第9题：

    单选题
    On Monday， you dropped the DEPT table from your schema and then you re/x7fcreated 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 can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.

    B

    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.

    C

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

    D

    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.


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

  • 第10题：

    单选题
    You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged.  With reference to this scenario， up to what point in time can the data be recovered？（）
    A

    until Thursday morning

    B

    until last Sunday’s backup

    C

    until Wednesday evening

    D

    until that point in time when the database is opened

    E

    until that point in time when the recovery is performed

    F

    until that point in time when the table is dropped and purged


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

  • 第11题：

    单选题
    You are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00 P.M. on Sunday.  How will you recover the dropped table， SCOTT.EMPLOYEE？（）
    A

     by using the Flashback Table feature

    B

     by using the Flashback Database feature

    C

     by performing incomplete recovery using RMAN utility

    D

     by performing incomplete recovery using user-managed recovery


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

  • 第12题：

    多选题
    You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）
    A

    Flashback logs are not archived.

    B

    Flashback logs are maintained in redo log files.

    C

    Flashback logs are maintained in the Flash Recovery Area.

    D

    Flashback logs are used to maintain Flashback Database related errors.

    E

    Flashback logs need to be cleared manually after you disable Flashback Database.


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

  • 第13题：

    You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， SupportCenter， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）

    • A、Use a flashback query to retrieve the rows that were deleted
    • B、Useconventialincremental export and then import the affected object
    • C、Shutdown the database inNORMALmode and restart the database instance
    • D、Use DBMS_META package to reconstruct the object using undo segments
    • E、UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data
    • F、Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.

    正确答案:B,E

  • 第14题：

    You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it.  Which constraints will remain enabled by default during this operation（）

    • A、CHECK
    • B、UNIQUE
    • C、NOT NULL
    • D、PRIMARY KEY
    • E、FOREIGN KEY

    正确答案:B,C,D

  • 第15题：

    User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）

    • A、 ALTER DATABASE FLASHBACK ON
    • B、 GRANT SELECT any transaction TO scott
    • C、 GRANT EXECUTE ON dbms_flashback TO scott
    • D、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
    • E、 ALTER TABLESPACE undots1 RETENTION GUARANTEE
    • F、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS

    正确答案:B,C,D,F

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

    In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

    • A、average row size
    • B、last analyzed date
    • C、size of table in bytes
    • D、size of table in database blocks
    • E、number of free blocks in the free list
    • F、number of extents present in the table

    正确答案:A,B,D

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

    多选题
    You work as a database administrator for Certkiller .com. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， Certkiller， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）
    A

    Use a flashback query to retrieve the rows that were deleted

    B

    Useconventialincremental export and then import the affected object

    C

    Shutdown the database inNORMALmode and restart the database instance

    D

    Use DBMS_META package to reconstruct the object using undo segments

    E

    UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data

    F

    Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.


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

  • 第20题：

    单选题
    You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table：  SQL> FLASHBACK TABLE ORDERS TO SCN 771513；   What is the prerequisite to perform Flashback Table？（）
    A

     You must configure OMF in your database.

    B

     You must enable block change tracking feature in your database.

    C

     You must enable ROW MOVEMENT feature on the ORDERS table.

    D

     You must use the Flashback Version Query before using the Flashback Table feature.


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

  • 第21题：

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


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

  • 第22题：

    单选题
    Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）
    A

     The database does not record flashback logs for MY_TABLESPACE

    B

     The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.

    C

     All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.

    D

     None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE


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

  • 第23题：

    单选题
    You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs？（）
    A

     LGWR

    B

     DBWR

    C

     MMON

    D

     RVWR


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

相关内容