网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）

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 reduced

B. All historical data older than 3 years is purged from the flashback archive FLA1

C. All historical data is retained but the subsequent flashback data archives are maintained for only 3 years

D. All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time

参考答案

更多 “ 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 ” 相关考题
考题 I have never been able to _________ down the magazine story. A. catchB. trailC. traceD. track
查看答案
考题 _____________[A] assist[B] track[C] sustain[D] dismiss
查看答案
考题 I______to be a scientist when I______ a boy.A、wanted, wasB、want, amC、wanted, amD、want, was
查看答案
考题 Which mode of database shutdown requires an instance recovery at the time of the next database startup?() A. ABORTB. NORMALC. IMMEDIATED. TRANSACTIONAL
查看答案
考题 中国ITS的特点有() A、适合国情的ITS技术发展模式B、ITS与基础设施同步发展C、ITS的学习和创新特点D、不分地区和阶段的发展特点
查看答案
考题 下列赋值语句中正确的是A．STORE 1 TO X,YB．STORE 1,2 TO XC．STORE 1 TO X YD．STORE 1、2 TO X
查看答案
考题 Youplantotakeacloseddatabasebackupusingoperatingsystemcommands.WhichthreeSHUTDOWNoptionsareappropriateforthistypeofbackup?() A.ABORTB.NORMALC.IMMEDIATED.TRANSACTIONAL
查看答案
考题 The company’s production has been put on the right ______.A.orbit B.course C.route D.track
查看答案
考题 下列赋值语句中正确的是A.STORE1ToX，Y B.STORE1，2ToX C.STORE1ToXY D.STORE1、2ToX
查看答案
考题 真核生物ITS序列由ITS1和ITS2两部分组成。
查看答案
热门标签
最新试卷