Which two statements regarding the Flashback Table feature a

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

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

第1题:

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action? ()(Choose two)

A. All the related indexes and views are automatically dropped

B. The flashback drop feature can recover only the table structure

C. Only the related indexes are dropped whereas views are invalidated

D. The flashback drop feature can recover both the table structure and its data


参考答案:C, D

第2题:

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

第3题:

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?()

A. All the related indexes and views are automatically dropped

B. The flashback drop feature can recover only the table structure

C. Only the related indexes are dropped whereas views are invalidated

D. The flashback drop feature can recover both the table structure and its data


参考答案:C, D

第4题:

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

  • A、 You can use this feature to identify the committed versions of the rows, but not the uncommitted versions.
  • B、 You can use this feature to identify the versions of V$ views.
  • C、 You can use this feature to identify the inserts, deletes, and updates performed on a particular row but not the data definition language (DDL) operations performed on the table.
  • D、 You can use this feature for a table only if row movement is enabled for the table.
  • E、 You can use this feature to identify the versions of external and fixed tables.

正确答案:A,C

第5题:

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

第6题:

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()

  • A、 Flashback logs are not archived.
  • B、 Flashback logs are maintained in redo log files.
  • C、 Flashback logs are maintained in the Flash Recovery Area.
  • D、 Flashback logs are used to maintain Flashback Database related errors.
  • E、 Flashback logs need to be cleared manually after you disable Flashback Database.

正确答案:A,C

第7题:

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? ()(Choose two)

  • A、All the related indexes and views are automatically dropped
  • B、The flashback drop feature can recover only the table structure
  • C、Only the related indexes are dropped whereas views are invalidated
  • D、The flashback drop feature can recover both the table structure and its data

正确答案:C,D

第8题:

Which statements are true regarding the Query Result Cache? ()

A. It can be set at the system, session, or table level.

B. It is used only across statements in the same session.

C. It can store the results from normal as well as flashback queries.

D. It can store the results of queries based on normal, temporary, and dictionary tables.


参考答案:A, C

第9题:

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()

  • A、UPDATE TABLE
  • B、CREATE CLUSTER
  • C、TRUNCATE TABLE
  • D、ALTER TABLE MOVE
  • E、INSERT INTO···VALUES
  • F、ALTER TABLE···DROP COLUMN
  • G、ALTER TABLE···DROP PARTITION

正确答案:A,E

第10题:

The RECYCLEBIN parameter is set to ON for your database. You drop a table,PRODUCTS,from the SCOTT schema.  Which two statements are true regarding the outcome of this action?()

  • A、 All the related indexes and views are automatically dropped
  • B、 The flashback drop feature can recover only the table structure
  • C、 Only the related indexes are dropped whereas views are invalidated
  • D、 The flashback drop feature can recover both the table structure and its data

正确答案:C,D

更多相关问题