违法和不良信息举报 联系客服
免费注册 登录

多选题For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）AUPDATE TABLEBCREATE CLUSTERCTRUNCATE TABLEDALTER TABLE MOVEEINSERT INTO···VALUESFALTER TABLE···DROP COLUMNGALTER TABLE···DROP PARTITION

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

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

第1题：

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table:SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP;What would be the outcome of the precedent statement?（）

A. It retrieves the latest version of the table from the recycle bin

B. It retrieves the oldest version of the table from the recycle bin

C. It retrieves the version of the table for which undo information is available

D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column


参考答案：A

第2题：

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

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

You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  

  • A、 Drop the table.
  • B、 Partition the table.
  • C、 Truncate the table.
  • D、 Add a column to the table.
  • E、 Rename a column in the table.

正确答案:D

第5题：

On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）

  • A、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
  • B、 You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
  • C、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
  • D、 You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

正确答案:B

第6题：

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

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

You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()

A. Drop the table.

B. Partition the table

C. Truncate the table.

D. Add a column to the table.

E. Rename a column in the table.


参考答案：D

第9题：

You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）

  • A、Drop the table.
  • B、Partition the table
  • C、Truncate the table.
  • D、Add a column to the table.
  • E、Rename a column in the table.

正确答案:D

第10题：

Which two operations can be flashed back using the Flashback technology？（）

  • A、DROP USER SMITH；
  • B、DROP TABLE EMPLOYEES；
  • C、DROP TABLESPACE USERS；
  • D、ALTER TABLE SALES_REP DROP PARTITION P1；
  • E、ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；

正确答案:A,B

更多相关问题
相关内容