1z0-043

多选题What are the prerequisites for enabling Flashback Database？ （）AThe database must be started in the MOUNT EXCLUSIVE state.BThe database must have multiplexed control files.CThe database must be opened by using a text-based parameter file instead of a se

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

The database must be started in the MOUNT EXCLUSIVE state.

B

The database must have multiplexed control files.

C

The database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.

D

The database must be in ARCHIVELOG mode.

E

The database must be in the NOMOUNT state.

F

The database must be opened in RESTRICTED mode.

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

第1题：

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

第2题：

Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）

  • A、 The database does not record flashback logs for MY_TABLESPACE
  • B、 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
  • C、 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
  • D、 None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

正确答案:A

第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题：

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 decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database？（）

  • A、 DB_RECOVERY_FILE_DEST only
  • B、 DB_FLASHBACK_RETENTION_TARGET only
  • C、 DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST only
  • D、 DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET only
  • E、 DB_RECOVERY_FILE_DEST_SIZE， DB_RECOVERY_FILE_DEST and
  • F、 DB_FLASHBACK_RETENTION_TARGET

正确答案:C

第6题：

You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1：   DROP FLASHBACK ARCHIVE fla1；   What is the effect of this command？（）

  • A、 The Flashback Archive FLA1 is dropped only if it is empty.
  • B、 The tablespace having Flashback Archive is dropped.
  • C、 The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
  • D、 The Flashback Data Archive and historical data are dropped.

正确答案:D

第7题：

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

第8题：

Which two are the prerequisites to enable Flashback Data Archive?() (Choose two.)

A. Database must be running in archivelog mode.

B. Automatic undo management must be enabled.

C. Undo retention guarantee must be enabled.

D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).


参考答案：B, D

第9题：

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

第10题：

You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time 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.

正确答案:D

更多相关问题
相关内容