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 th

题目

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

相似考题

1.I have never been able to _________ down the magazine story.A. catchB. trailC. traceD. track

2.I______to be a scientist when I______ a boy.A、wanted, wasB、want, amC、wanted, amD、want, was

3.Which mode of database shutdown requires an instance recovery at the time of the next database startup?()A. ABORTB. NORMALC. IMMEDIATED. TRANSACTIONAL

4._____________[A] assist[B] track[C] sustain[D] dismiss

参考答案和解析
参考答案：B
更多“You want to track and store all transactional changes to a table over its lifetime. To acc ”相关问题

  • 第1题：

    中国ITS的特点有()

    A、适合国情的ITS技术发展模式

    B、ITS与基础设施同步发展

    C、ITS的学习和创新特点

    D、不分地区和阶段的发展特点


    参考答案：ABC

  • 第2题：

    Youplantotakeacloseddatabasebackupusingoperatingsystemcommands.WhichthreeSHUTDOWNoptionsareappropriateforthistypeofbackup?()

    A.ABORT

    B.NORMAL

    C.IMMEDIATE

    D.TRANSACTIONAL


    参考答案：B, C, D

  • 第3题：

    下列赋值语句中正确的是

    A.STORE1ToX，Y
    B.STORE1，2ToX
    C.STORE1ToXY
    D.STORE1、2ToX

    答案：A
    解析：

  • 第4题：

    下列赋值语句中正确的是

    A．STORE 1 TO X,Y

    B．STORE 1,2 TO X

    C．STORE 1 TO X Y

    D．STORE 1、2 TO X


    正确答案：A
    解析：利用STORE命令给变量赋值，可以一次性给多个变量赋以相同的变量值，且各个变量名之间应该用逗号隔开，但不能将多个变量值赋给一个变量或多个变量。

  • 第5题：

    The company’s production has been put on the right ______.

    A.orbit
    B.course
    C.route
    D.track

    答案：D
    解析：
    本题考察名词，题目意为“该公司的生产已走上正轨。”A选项意为“轨道、眼眶、势力范围”，B选项意为“课程、航线”，C选项意为“航线、路”，D选项意为“轨道、路线”。固定搭配on the right track ，意为“走上正轨”。
    　　

  • 第6题：

    真核生物ITS序列由ITS1和ITS2两部分组成。


    编码序列

相关内容