单项选择题

You decided to change the location of the flash recovery area. You executed the following command： Which statement is true？（）

A.The location can be changed only if the flash recovery area is empty.
B.After executing the command， all new flash recovery area files will be created in the new location.
C.The command will generate an error because you cannot change the flash recovery area while the database is open.
D.All the existing files in the flash recovery area will be moved to the new location， and all new Flash Recovery Area files will be created in the new location.

<上一题目录下一题>

热门试题

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