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

多选题What two are the prerequisites for enabling Flashback Database?（）AThe database must be in ARCHIVELOG modeBThe database must be in MOUNT EXCLUSIVE modeCThe database must be opened in RESTRICTED modeDThe database instance must be started in the NOMOUNT s

题目
多选题
What two are the prerequisites for enabling Flashback Database?（）
A

The database must be in ARCHIVELOG mode

B

The database must be in MOUNT EXCLUSIVE mode

C

The database must be opened in RESTRICTED mode

D

The database instance must be started in the NOMOUNT state

E

The database instance must have the keep buffer pool defined

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

第1题：

You are managing a 24*7 database. The backup strategy for the database is to perform user－managedbackups.Identify two prerequisites to perform the backups. (Choose two.)()

A. The database must be opened in restricted mode.

B. The database must be configured to run in ARCHIVELOG mode.

C. The tablespaces are required to be in backup mode before taking the backup.

D. The tablespaces are required to be in read-only mode before taking the backup


参考答案：B, C

第2题：

Which two are prerequisites for performing a flashback transaction?()

A. Flashback Database must be enabled.

B. Undo retention guarantee for the database must be configured.

C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

D. Supplemental logging must be enabled.

E. Recycle bin must be enabled for the database.

F. Block change tracking must be enabled tor the database.


参考答案：B, C

第3题：

What two are the prerequisites for enabling Flashback Database?()

A. The database must be in ARCHIVELOG mode

B. The database must be in MOUNT EXCLUSIVE mode

C. The database must be opened in RESTRICTED mode

D. The database instance must be started in the NOMOUNT state

E. The database instance must have the keep buffer pool defined


参考答案：A, B

第4题：

You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）

  • A、You must have started the database instance in restricted mode.
  • B、You must have started the database instance inNORMALmode.
  • C、You must have started the database instance with server parameter file.
  • D、You must have started the database instance but must not have mounted.
  • E、You must have started the database instance but must not have opened.

正确答案:C

第5题：

You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）

  • A、The source database backup must be copied over the net for test database.
  • B、The source database must be run in ARCHIVELOG mode if the database is open.
  • C、The source database must be shut down cleanly if the database is in mounted state.
  • D、A net service name should be set up and a listener configured with the target as well as the source database.

正确答案:B,C,D

第6题：

What two are the prerequisites for enabling Flashback Database?() (Choose two)

A. The database must be in ARCHIVELOG mode

B. The database must be in MOUNT EXCLUSIVE mode

C. The database must be opened in RESTRICTED mode

D. The database instance must be started in the NOMOUNT state

E. The database instance must have the keep buffer pool defined


参考答案：A, B

第7题：

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

第8题：

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

第9题：

What two are the prerequisites for enabling Flashback Database?（） (Choose two)

  • A、The database must be in ARCHIVELOG mode
  • B、The database must be in MOUNT EXCLUSIVE mode
  • C、The database must be opened in RESTRICTED mode
  • D、The database instance must be started in the NOMOUNT state
  • E、The database instance must have the keep buffer pool defined

正确答案:A,B

第10题：

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

更多相关问题
相关内容