单选题

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.

正确答案

答案解析

略

相似试题

You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario（）
多选题查看答案
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）
多选题查看答案
You are managing an Oracle Database 11g database. The database is open， and you plan to performRecovery Manager （RMAN） backups. Which three statements are true about these backups（）
多选题查看答案
You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups. Which three statements are true about these backups（）
多选题查看答案
You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance： SQL> ALTER SYSTEM SWITCH LOGFILE； Which two tasks are performed when the statement is executed？（）
多选题查看答案
You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests. Which naming method can you use？（）
单选题查看答案
You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. Which configuration will you do to accomplish the task（）
单选题查看答案
You are working on the Certkiller database. What is the default name of the alert log file in this database？（）
单选题查看答案
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？（）
多选题查看答案
You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database. Which information is NOT required during the migration process？（）
单选题查看答案

语音搜题

拍照搜题

打赏

Oracle认证

正确答案

答案解析