单项选择题

A.Flashback logs are not deleted.B.Flashback logs are d……

You disabled the Flashback Database feature by using the following command：
SQL> ALTER DATABASE FLASHBACK OFF;
What would be the effect of this command on the existing flashback logs？（）

A.Flashback logs are not deleted.
B.Flashback logs are deleted automatically.
C.Flashback logs are deleted only if you are using Recovery Manager （RMAN）.
D.Flashback logs are deleted only if you are using Oracle Managed Files （OMF）.
E.Flashback logs are deleted only if you are using Automatic Storage Management （ASM）.

<上一题目录下一题>

热门试题

单项选择题InwhichcasewouldyouusetheFlashbackDatabasefeaturetoperformarecovery？（）

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

单项选择题View the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a ？） in the Flashback Database architecture.（）

A.DBWn
B.RVWR
C.ARCH
D.RECO
E.TRWR

多项选择题You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5 24） Which two statements are true？（）

A.SYSDATE should not be used with TIMESTAMP.
B.The database must have multiplexed redo log files.
C.The database must be in the MOUNT state to execute the command.
D.The database must be opened with the RESETLOGS option after the flashback operation.
E.The entire database needs to be restored from the most recent backup before the flashback operation.

单项选择题OnTuesday，ajuniorDBAdroppedanimportantapplicationuseraccount，whoseschemahasimportanttables.Youareaskedtorecoveralltheobjectsintheschema.Oninvestigation，youfindthattheuseraccountwasdroppedat11：00a.m.andSunday’sbackupisthemostrecentbackup.Whichflashbackfeaturewouldyouuse？（）

A.Flashback Drop
B.Flashback Table
C.Flashback Database
D.Flashback Version Query
E.Flashback Transaction Query

单项选择题A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

A.flash back all the tables in the data file， one by one
B.restore the data file to a new location and perform a media recovery
C.flash back the database; there is no need to restore the data file
D.restore the data file from the most recent backup and flash back the database