Which two are the prerequisites to enable Flashback Data Arc

题目
多选题
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).

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

第1题:

Which two client requests are captured during database replay Capture?() (Choose two)

A. Flashback queries

B. Shared server requests

C. Login and logoff activities of sessions

D. Direct path load of data from external files by using utilities such as SQL *loader

E. Data definition language (DDL) and data manipulation language (DML) operations


参考答案:C, E

第2题:

You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions?()

A. Enable supplemental logging for the database.

B. Specify undo retention guarantee for the database.

C. Create a Flashback Data Archive in the tablespace where the tables are stored.

D. Create a Flashback Data Archive in any suitable tablespace.

E. Enable Flashback Data Archiving for the tables that require tracking


参考答案:D, E

第3题:

You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?()

A. Enable supplemental logging for the database.

B. Specify undo retention guarantee for the database

C. Create Flashback Data Archive in the tablespace where the tables are stored.

D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables


参考答案:D

第4题:

Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()

  • A、 DBWn
  • B、 RECO
  • C、 RVWR
  • D、 LGWR

正确答案:C

第5题:

Which of the following statements best describes Flashback Versions Query?()  

  • A、 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.
  • B、 Flashback Versions Query is used to view all version changes on rows that existed between the time  the query was executed and a point in time in the past.
  • C、 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.
  • D、 Flashback Versions Query is used to view all version changes on rows that existed between two  points in time.

正确答案:D

第6题:

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

第7题:

Which two client requests are captured during database replay Capture?()

  • A、Flashback queries
  • B、Shared server requests
  • C、Login and logoff activities of sessions
  • D、Direct path load of data from external files by using utilities such as SQL *loader
  • E、Data definition language (DDL) and data manipulation language (DML) operations

正确答案:C,E

第8题:

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

第9题:

Which two statements regarding the Flashback Table feature are correct?()

  • A、Flashback Table can be performed on system tables.
  • B、Flashback Table operation does not shrink the segments.
  • C、Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
  • D、Flashback Table operation acquires exclusive data manipulation language (DML) locks.

正确答案:B,D

第10题:

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

更多相关问题