名词解释题Adjusted retention time
名词解释题
Adjusted retention time
参考解析
解析：
暂无解析
相关考题：
The income statement is prepared from (). A.the income statement columns of the work sheetB.the adjusted trial balanceC.either the adjusted trial balance or the income statement columns of the work sheetD.both the adjusted trial balance and the income statement columns of the work sheet
When a process is in control, what do you want to do with the process?（）.A.The process should not be adjustedB.The process may be adjusted for continuous improvementC.The process should be always adjusted for continuous qualityD.The process should be regularly adjusted
In Recovery Manager （RMAN）， you set the retention policy to NONE by executing the following command： CONFIGURE RETENTION POLICY TO NONE; What would be the impact of this setting？（）A、The retention policy is cleared.B、RMAN does not consider any backup as obsolete.C、The retention policy is set to its default setting of redundancy 1.D、The retention policy is set to its default setting of recovery window 7.
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?（）A、An upper limit on how far you can flash back the database, depending on the information in the redo logsB、An upper limit on how far you can flash back the database, depending on the information in the undo tablespaceC、The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough spaceD、The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space
You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database？（）A、 DB_RECOVERY_FILE_DEST onlyB、 DB_FLASHBACK_RETENTION_TARGET onlyC、 DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST onlyD、 DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET onlyE、 DB_RECOVERY_FILE_DEST_SIZE， DB_RECOVERY_FILE_DEST andF、 DB_FLASHBACK_RETENTION_TARGET
You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）A、By multiplexing the control filesB、By multiplexing the redo log filesC、By decreasing the size of redo log filesD、By configuring mean time to recover （MTTR） to a lower valueE、By setting the UNDO_RETENTION parameter to a higher value
Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）A、It is the time period after which the undo data becomes obsolete.B、It is the time period after which the committed undo data would be transferred to a temporarytablespace.C、It is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.D、It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
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.
Which two statements regarding the control file and Recover Manager are true？ （）A、The control file can grow in size.B、The control file can store RMAN scripts.C、CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.D、The RMAN catalog can exist solely in the control file of the target database.
The following command is executed to create the baseline template： SQL EXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE（START_TIME= TO_TIESTAMP（SYSDATE+2）， END_TIME=TO_TIMESTAMP（SYSDATE+10）， BASELINE_NAME=’Mybase4’， TEMPLATE_NAME=’Mytemp4’， EXPIRATION=NULL）； Which statement is true about the effect of the above command？（） A、 It creates a baseline template that never expires.B、 It produces an error because no snapshot information is provided to create the baseline.C、 It creates a baseline template that expires after the Automatic Workload Repository （AWR） retention period.D、 It creates a repeating baseline template that repeats after the Automatic Workload Repository （AWR） retention period.
单选题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.
单选题The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?（）Aset DB_FLASHBACK_RETENTION_TARGET=10800 Bcreate a new scheduler window for the time period of 24 hours and use the optimizer statistics Cmodify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings Dspecify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations
单选题If a single cylinder relief valve on a diesel engine lists frequently while the engine is running, the cause may be an （）Aexcessively late injection timing for each cylinderBincorrectly adjusted intake valve timingCincorrectly adjusted fuel injectorDincorrectly adjusted intake valve clearance
单选题When daylight savings time is kept，the time of tide and current calculations must be adjusted.One way of doing this is to（）.AAdd one hour to the times listed under the reference stationsBSubtract one hour from the time differences listed for the subordinate stationsCApply no correction as the times in the reference stations are adjusted for daylight savings timeDAdd 15° to the standard meridian when calculating the time difference
单选题In Recovery Manager （RMAN）， you set the retention policy to NONE by executing the following command： CONFIGURE RETENTION POLICY TO NONE; What would be the impact of this setting？（）AThe retention policy is cleared.BRMAN does not consider any backup as obsolete.CThe retention policy is set to its default setting of redundancy 1.DThe retention policy is set to its default setting of recovery window 7.
单选题You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database？（）A DB_RECOVERY_FILE_DEST onlyB DB_FLASHBACK_RETENTION_TARGET onlyC DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST onlyD DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET onlyE DB_RECOVERY_FILE_DEST_SIZE， DB_RECOVERY_FILE_DEST andF DB_FLASHBACK_RETENTION_TARGET
单选题The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?（）ACreate two custom ADDM tasks.BModify the AWR snapshot time interval to two hours.CCreate a new scheduler window for a time period of two hours.DModify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
多选题Which two statements regarding the control file and Recover Manager are true？ （）AThe control file can grow in size.BThe control file can store RMAN scripts.CCONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.DThe RMAN catalog can exist solely in the control file of the target database.
多选题You are working on a test database where instance recovery takes a considerable amount of time. How can reduce the recovery time？（）ABy multiplexing the control filesBBy multiplexing the redo log filesCBy decreasing the size of redo log filesDBy configuring mean time to recover （MTTR） to a lower valueEBy setting the UNDO_RETENTION parameter to a higher value
单选题What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）A An upper limit on how far you can flash back the database，depending on the information in the redo logsB An upper limit on how far you can flash back the database，depending on the information in the undo tablespaceC The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough spaceD The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space
多选题You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）Aset SQL_TRACE=TrueBset UNDO_RETENTION=14400Cset FAST_START_MTTR_TARGET=240Dset LOG_CHECKPOINT_INTERVAL=240Eset DB_FLASHBACK_RETENTION_TARGET=14400Fset the RETENTION GUARANTEE clause for the undo tablespace
单选题Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）AIt is the time period after which the undo data becomes obsolete.BIt is the time period after which the committed undo data would be transferred to a temporarytablespace.CIt is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.DIt is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
单选题Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled（）AIt is the time period after which the undo data becomes obsolete.BIt is the time period after which the committed undo data would be transferred to a temporary tablespace.CIt is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.DIt is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
单选题The following command is executed to create the baseline template： SQL EXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE（START_TIME= TO_TIESTAMP（SYSDATE+2）， END_TIME=TO_TIMESTAMP（SYSDATE+10）， BASELINE_NAME=’Mybase4’， TEMPLATE_NAME=’Mytemp4’， EXPIRATION=NULL）； Which statement is true about the effect of the above command？（）A It creates a baseline template that never expires.B It produces an error because no snapshot information is provided to create the baseline.C It creates a baseline template that expires after the Automatic Workload Repository （AWR） retention period.D It creates a repeating baseline template that repeats after the Automatic Workload Repository （AWR） retention period.
单选题Which statement is true regarding Flashback Version Query？（）A It returns versions of rows only within a transaction.B It can be used in subqueries contained only in a SELECT statement.C It will return an error if the undo retention time is less than the lower bound time or SCN specified.D It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.
单选题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