多选题You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）AThe database must have multiplexed redo logs for the flash

题目

多选题

You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）

The database must have multiplexed redo logs for the flashback to succeed.

The database must be MOUNTED for the flashback to succeed.

The database must use block change tracking for the flashback to succeed.

The database must be opened in restricted mode for the flashback to succeed.

The database must be opened with the RESETLOGS option after the flashback is complete.

The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

参考答案和解析

正确答案： A,C

解析：暂无解析

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Which three statements are true about using flashback database in a multitenant container database(CDB)?()

A. The root container can be flashed back without flashing back the pluggable databases (PDBs).

B. To enable flashback database, the CDB must be mounted.

C. Individual PDBs can be flashed back without flashing back the entire cdb.

D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.

E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

参考答案：B, C, D

第2题：

You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？（）

A、 Open the database in read-only mode.
B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
C、 Enable the block change tracking feature.
D、 Execute the ALTER DATABASE FLASHBACK ON statement.

正确答案:A,C

第3题：

You plan to execute the following command to perform a Flashback Database operation in your database:SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE －5／24);Which two statements are true about this?()

A. The database must have multiplexed redo log files

B. The database must be in the MOUNT state to execute the command

C. The database must be in the NOMOUNT state to execute the command

D. The database must be opened in RESTRICTED mode before this operation

E. The database must be opened with the RESETLOGS option after the flashback operation

参考答案：B, E

第4题：

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 Manager Files （OFM）
E、 Flashback logs are deleted only if you are using Automatic Storage Management （ASM）

正确答案:B

第5题：

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.

正确答案:C,D

第6题：

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？（）

A、 Flashback logs are not archived.
B、 Flashback logs are maintained in redo log files.
C、 Flashback logs are maintained in the Flash Recovery Area.
D、 Flashback logs are used to maintain Flashback Database related errors.
E、 Flashback logs need to be cleared manually after you disable Flashback Database.

正确答案:A,C

第7题：

Which three statements are true about using flashback database in a multitenant container database(CDB)?（）

A、The root container can be flashed back without flashing back the pluggable databases (PDBs).
B、To enable flashback database, the CDB must be mounted.
C、Individual PDBs can be flashed back without flashing back the entire cdb.
D、The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.
E、A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

正确答案:B,C,D

第8题：

You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE － 5／24);Which two statements are true about this flashback scenario?()

A. The database must have multiplexed redo logs for the flashback to succeed.

B. The database must be MOUNTED for the flashback to succeed.

C. The database must use block change tracking for the flashback to succeed.

D. The database must be opened in restricted mode for the flashback to succeed.

E. The database must be opened with the RESETLOGS option after the flashback is complete.

F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

参考答案：E, F

第9题：

You plan to execute the following command to perform a Flashback Database operation in your database： SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）； Which two statements are true about this？（）

A、 The database must have multiplexed redo log files
B、 The database must be in the MOUNT state to execute the command
C、 The database must be in the NOMOUNT state to execute the command
D、 The database must be opened in RESTRICTED mode before this operation
E、 The database must be opened with the RESETLOGS option after the flashback operation

正确答案:B,E

第10题：

These are the details about V$FLASHBACK_DATABASE_STAT： SQL> DESC V$FLASHBACK_DATABASE_STAT Name Null？ Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME DATE FLASHBACK_DATA NUMBER DB_DATA NUMBER REDO_DATA NUMBER ESTIMATED_FLASHBACK_SIZE NUMBER Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true？（）

A、BEGIN_TIME is the time at which Flashback logging is enabled.
B、END_TIME is the time at which the query is executed on the view.
C、REDO_DATA is the number of bytes of redo data written during the interval.
D、This view contains information about flashback data pertaining to the last 24 hours.
E、FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

正确答案:C,D

多选题You want to flash back a test database by five hours.You issue this command:SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）AThe database must have multiplexed redo logs for the flashb

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容