违法和不良信息举报 联系客服
免费注册 登录

多选题Which three actions are required to configure the Flashback Database？（）Aset Flash Recovery AreaBenable Flashback loggingCcreate FLASHBACK tablespaceDstart the database in the ARCHIVELOG modeEstart the database in the NOARCHIVELOG mode

题目
多选题
Which three actions are required to configure the Flashback Database？（）
A

set Flash Recovery Area

B

enable Flashback logging

C

create FLASHBACK tablespace

D

start the database in the ARCHIVELOG mode

E

start the database in the NOARCHIVELOG mode

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

第1题：

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

第2题：

Flashback Database relies on which technologies to recover to a point in time？（）  

  • A、 Flashback Data Archive
  • B、 Flashback logs in the flash recovery area
  • C、 FlashbUndo tablespace
  • D、 RMAN command line
  • E、 None of the above

正确答案:B

第3题：

Which three actions are required to configure the Flashback Database? ()

A. set Flash Recovery Area

B. enable Flashback logging

C. create FLASHBACK tablespace

D. start the database in the ARCHIVELOG mode

E. start the database in the NOARCHIVELOG mode


参考答案：A, B, D

第4题：

The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）

  • A、 Enable flashback logging.
  • B、 Start the database in the ARCHIVELOG mode.
  • C、 Issue the ALTER DATABASE FLASHBACK ON； command.
  • D、 Set the FAST_START_MTTR_TARGET initialization parameter.

正确答案:A

第5题：

You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required？（）

  • A、 V$DATABASE
  • B、 V$FLASHBACK_DATABASE_STAT
  • C、 V$FLASHBACK_DATABASE_LOG
  • D、 V$RECOVERY_FILE_DEST

正确答案:B

第6题：

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

第7题：

In order to perform Flashback Transaction Query operations， which of these steps are required？（）

  • A、 Ensure that database is running with version 10.1 compatibility.
  • B、 Enable Flashback Logging.
  • C、 Enable Supplemental Logging.
  • D、 Ensure that the database is running with version 10.0 compatibility.
  • E、 Ensure that the database is in ARCHIVELOG mode.

正确答案: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题：

Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 

  • A、 Database datafiles
  • B、 Control files
  • C、 Archived redo logs
  • D、 Online redo logs
  • E、 Flashback logs

正确答案:A,B,D

第10题：

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）  

  • A、 An upper limit on how far you can flash back the database，depending on the information in the redo logs
  • B、 An upper limit on how far you can flash back the database，depending on the information in the undo tablespace
  • C、 The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough space
  • D、 The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space

正确答案:C

更多相关问题
相关内容