CMS专题

多选题Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)AFlash recovery area must be definedBUndo retention guarantee must be enabled.CDatabase must be running in archivelog mode.DAutomatic undo management must be enabl

题目
多选题
Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)
A

Flash recovery area must be defined

B

Undo retention guarantee must be enabled.

C

Database must be running in archivelog mode.

D

Automatic undo management must be enabled.

E

The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

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

第1题：

You are proceeding down a channel and lose the engine（s）．You must use the anchors to stop the ship．Which statement is true ________．

A.Pay out all of the cable before setting up on the brake to insure the anchors dig in and hold

B.For a mud，mud and clay，or sandy bottom pay out a scope of 5 to 7 times the depth before setting up on the brake

C.Use one or both anchors with a scope of twice the depth before setting the brake

D.Drop the anchor to short stay and hold that scope


正确答案：C

第2题：

Which two of these correctly describe Fibre Channel? （）

  • A、supports multiple protocols
  • B、works only in a shared or loop environment
  • C、allows addressing for up to 4 million nodes
  • D、allows addressing for up to 8 million nodes
  • E、provides a high speed transport for SCSI payloads
  • F、may stretch to a distance of up to100 km before needing extenders

正确答案:A,E

第3题：

Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.)

A. Flash recovery area must be defined

B. Undo retention guarantee must be enabled.

C. Database must be running in archivelog mode.

D. Automatic undo management must be enabled.

E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).


参考答案：D, E

第4题：

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

第5题：

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

第6题：

Which two of these correctly describe Fibre Channel？（）

  • A、 supports multiple protocols
  • B、 works only in a shared or loop environment
  • C、 allows addressing for up to 4 million nodes
  • D、 allows addressing for up to 8 million nodes
  • E、 provides a high speed transport for SCSI payloads
  • F、 may stretch to a distance of up to 100 km before needing extenders

正确答案:A,E

第7题：

If a technician is traveling outside of the US, which of the following should be checked before setting up a workstation? （）

  • A、Local file format
  • B、Wattage setting
  • C、Local power codes
  • D、Voltage setting

正确答案:D

第8题：

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

第9题：

You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？ （）

  • A、 RESETLOGS
  • B、 TO TIMESTAMP
  • C、 TO BEFORE DROP
  • D、 RENAME TO
  • E、 TO SCN

正确答案:B,E

第10题：

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

更多相关问题
相关内容