Which two are prerequisites for performing a flashback trans

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

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

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

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

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

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

第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 CIFS commands are accelerated by AppFlow? ()(Choose two.)

A. ReadX

B. Write AndX

C. Trans2 Query

D. Tree Disconnect


参考答案:A, B

第7题:

Which two CIFS commands are accelerated by AppFlow? ()(Choose two.)

  • A、ReadX
  • B、Write AndX
  • C、Trans2 Query
  • D、Tree Disconnect

正确答案:A,B

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

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题:

Which two prerequisites are needed for performing workload capture and replay?()

  • A、Close all sessions performing queries using database links
  • B、running the database in shared server mode
  • C、The database on which the workload is replayed has to be a restore of the original database to a specific SCN
  • D、setting up the directory to capture the workload

正确答案:C,D

更多相关问题