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

相关问题推荐

• An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace：   1. You log on to Enterprise Manager as SYSDBA.    2. You select the maintenance screen.    3. You choose Perform Recovery option on the maintenance screen.    4. You choose Whole Database in the Object Type drop-down list Perform Recovery： Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery： Type screen.    6. You provide the Host Credentials for a database user. on the Perform Recovery： Type screen.    7. You click the continue button.    An information screen appears saying that the database is unavailable. What is this information screen？（）

  A、Recovery Manager

  B、Recovery Window

  C、Recovery Wizard

  D、Enterprise Manager Home Page

  查看答案

• Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）

  A、recovery cannot be performed because a backup was not performed after the last incomplete recovery

  B、restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday

  C、restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday

  D、restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday

  查看答案

• Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace space usage metrics is set to 70%.  To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do？（）

  A、disable SQL tracing for theAPPS tablespace

  B、disable logging attribute for the APPS tablespace

  C、modify the tablespace to be a dictionary­managed tablespace

  D、increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace

  E、increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace

  查看答案

• 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

  查看答案

• You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands：   CONFIGURE DEFAULT DEVICE TYPE TO sbt；   CONFIGURE BACKUP OPTIMIZATION ON；   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   From Monday to Saturday， you performed the following actions：   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed？（）

  A、 The backup will not be performed at all.

  B、 three times

  C、 four times

  D、 six times

  查看答案