单选题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 reten

题目

单选题

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?（）

Enable supplemental logging for the database.

Specify undo retention guarantee for the database

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

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

参考答案和解析

正确答案： B

解析：暂无解析

如果没有搜索结果，请直接联系老师获取答案。

更多相关问题

相关问题 1：

多选题You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）Aguarantee undo retentionBadd one more redo log groupCsize the redo log files appropriatelyDsize the UNDO tablespace appropriatelyEsize the SYSTEM tablespace appropriatelyFconfigure an appropriate undo retention intervalGchange automatic undo management to manual

点击查看答案
相关问题 2：

单选题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 databaseC 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

点击查看答案
相关问题 3：

多选题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?（）AEnable supplemental logging for the database.BSpecify undo retention guarantee for the database.CCreate a Flashback Data Archive in the tablespace where the tables are stored.DCreate a Flashback Data Archive in any suitable tablespace.EEnable Flashback Data Archiving for the tables that require tracking

点击查看答案
相关问题 4：

单选题You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）A ALTER DATABASE B SET TRANSACTION C ALTER ROLLBACK SEGMENT D ALTER TABLE

点击查看答案
相关问题 5：

单选题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？（）AEnable supplemental logging for the database.BSpecify undo retention guarantee for the databaseCCreate Flashback Data Archive in the tablespace where the tables are stored.DCreate Flashback Data Archive and enable Flashback Data Archive for specific tables

点击查看答案
相关问题 6：

多选题Which two are the prerequisites to enable Flashback Data Archive？（）ADatabase must be running in archivelog mode.BAutomatic undo management must be enabled.CUndo retention guarantee must be enabled.DThe tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management （ASSM）.

点击查看答案
相关问题 7：

多选题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?（）AEnable supplemental logging for the database.BSpecify undo retention guarantee for the database.CCreate a Flashback Data Archive in the tablespace where the tables are stored.DCreate a Flashback Data Archive in any suitable tablespace.EEnable Flashback Data Archiving for the tables that require tracking

点击查看答案

OCP 11G认证考试

单选题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 reten

题目

参考答案和解析

更多相关问题

相关问题 1：

相关问题 2：

相关问题 3：

相关问题 4：

相关问题 5：

相关问题 6：

相关问题 7：

相关内容