首页计算机考试Oracle认证
(单选题)

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

正确答案

来源:www.examk.com

答案解析

相似试题

  • (多选题)

    Which two are the prerequisites to enable Flashback Data Archive?()

    答案解析

  • (单选题)

    Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()

    答案解析

  • (单选题)

    You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?()  

    答案解析

  • (多选题)

    When setting up the Flashback Data Archive, which of these key parameters are required?()

    答案解析

  • (单选题)

    You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()

    答案解析

  • (单选题)

    To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do?()  

    答案解析

  • (多选题)

    You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature? ()

    答案解析

  • (单选题)

    You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()

    答案解析

  • (单选题)

    You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?()

    答案解析

  • (单选题)

    Which statement is true regarding Flashback Version Query?()

    答案解析

快考试在线搜题