单选题To clean up old records that are in a Flashback Data Archive and are past the retention period， what must the DBA do？（）A TRUNCATE the archive table.B DROP the Flashback Data Archive.C Nothing；expired rows are automatically removed.D Nothing；expired rows are moved to an archive table.E Delete entries from the archive where the metadata date retained is greater than the retention period.
单选题
To clean up old records that are in a Flashback Data Archive and are past the retention period， what must the DBA do？（）
A
TRUNCATE the archive table.
B
DROP the Flashback Data Archive.
C
Nothing；expired rows are automatically removed.
D
Nothing；expired rows are moved to an archive table.
E
Delete entries from the archive where the metadata date retained is greater than the retention period.
参考解析
解析：
暂无解析
相关考题：
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
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 tableC. Truncate the table.D. Add a column to the table.E. Rename a column in the table.
Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.) A. Flash recovery area must be definedB. 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).
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.
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 tableC、Truncate the table.D、Add a column to the table.E、Rename a column in the table.
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.
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
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
Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)A、Flash recovery area must be definedB、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).
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 are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS; What is the outcome of this command?（）A、The command produces an error because the retention period cannot be reducedB、All historical data older than 3 years is purged from the flashback archive FLA1C、All historical data is retained but the subsequent flashback data archives are maintained for only 3 yearsD、All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time
Which two are the prerequisites to enable Flashback Data Archive?（） (Choose two.)A、Database must be running in archivelog mode.B、Automatic undo management must be enabled.C、Undo retention guarantee must be enabled.D、The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
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.
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.
To clean up old records that are in a Flashback Data Archive and are past the retention period， what must the DBA do？（） A、 TRUNCATE the archive table.B、 DROP the Flashback Data Archive.C、 Nothing；expired rows are automatically removed.D、 Nothing；expired rows are moved to an archive table.E、 Delete entries from the archive where the metadata date retained is greater than the retention period.
Note the output of the following query； SQL SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1 You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table： ALTER TABLE exchange_rate FLASHBACK ARCHIEVE； What is the outcome of this command？（） A、 The table uses the default Flashback Data Archive.B、 The Flashback Data Archive Is created In the SYSAUX tablespace.C、 The Flashback Data Archive is created in the same tablespace where the tables are stored.D、 The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.
Which two are the prerequisites to enable Flashback Data Archive？（）A、 Database must be running in archivelog mode.B、 Automatic undo management must be enabled.C、 Undo retention guarantee must be enabled.D、 The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management （ASSM）.
单选题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 are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS; What is the outcome of this command?（）AThe command produces an error because the retention period cannot be reducedBAll historical data older than 3 years is purged from the flashback archive FLA1CAll historical data is retained but the subsequent flashback data archives are maintained for only 3 yearsDAll historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time
多选题When setting up the Flashback Data Archive， which of these key parameters are required？（）ATablespace nameBStorage quotaCRetentionDTable nameECreate a default archive
单选题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.
单选题To clean up old records that are in a Flashback Data Archive and are past the retention period， what must the DBA do？（）A TRUNCATE the archive table.B DROP the Flashback Data Archive.C Nothing；expired rows are automatically removed.D Nothing；expired rows are moved to an archive table.E Delete entries from the archive where the metadata date retained is greater than the retention period.
单选题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.
单选题What is the implication of this command?（）AThe command produces an error because the retention time cannot be reduced. BAll historical data is retained but the subsequent flashback data archives are maintained for only three years. CAll historical data is purged and the new flashback data archives are maintained for three years. DAll historical data older than three years is purged from the flashback archive FLA1.
单选题Note the output of the following query； SQL SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1 You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table： ALTER TABLE exchange_rate FLASHBACK ARCHIEVE； What is the outcome of this command？（）A The table uses the default Flashback Data Archive.B The Flashback Data Archive Is created In the SYSAUX tablespace.C The Flashback Data Archive is created in the same tablespace where the tables are stored.D The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.
单选题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.
单选题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
单选题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
多选题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）.
单选题You are working on the APPDB database as a DBA. 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?（）AThe Flashback Archive FLA1 is dropped only if it is empty.BThe tablespace having Flashback Archive is dropped.CThe Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.DThe Flashback Data Archive and historical data are dropped.