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

You enabled Flashback Data Archive on the INVENTORY table. W

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

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

第1题：

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

第2题：

You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1：   DROP FLASHBACK ARCHIVE fla1；   What is the effect of this command？（）

  • A、 The Flashback Archive FLA1 is dropped only if it is empty.
  • B、 The tablespace having Flashback Archive is dropped.
  • C、 The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
  • D、 The Flashback Data Archive and historical data are dropped.

正确答案:D

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

You want to track and store all transactional changes to a table over its lifetime. To accomplish this task， you enabled Flashback Data Archive with the retention of 5 years. After some time， the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this， you issued the following command：   ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR；   What is the implication of this command？（）

  • A、 The command produces an error because the retention time cannot be reduced.
  • B、 All historical data is retained but the subsequent flashback data archives are maintained for only three years.
  • C、 All historical data is purged and the new flashback data archives are maintained for three years.
  • D、 All historical data older than three years is purged from the flashback archive FLA1.

正确答案:D

第5题：

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

第6题：

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

第7题：

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

第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 are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）

  • A、 Enable Flashback Data Archive for the tables.
  • B、 Specify undo retention guarantee for the database.
  • C、 Enable supplemental logging for the database.
  • D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
  • E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

正确答案:A

第10题：

When setting up the Flashback Data Archive， which of these key parameters are required？（）

  • A、 Tablespace name
  • B、 Storage quota
  • C、 Retention
  • D、 Table name
  • E、 Create a default archive

正确答案:A,C

更多相关问题
相关内容