FlashbackDatabaseisenabledinyourOracle10gdatabase.Oneof

1z0-043

单项选择题

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

相关考题

单项选择题 You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：\product\10.1.0\flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）

单项选择题 Youhaveconfiguredtheflashrecoveryareatostoreonlineredologfiles，controlfiles，archivedredologsandRMANbackups.Whichofthefollowingfilescanyousuccessfullydeletefromtheflashrecoveryareaifyouwanttoreclaimthespacewithinit？（）

单项选择题 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？（）