单项选择题

A.the time when the last flashback operation in your da……

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

<上一题目录下一题>

热门试题

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