欢迎来到求知题库网 求知题库官网
logo
全部科目 > Oracle认证考试 > 1z0-043

单项选择题

You are working as a DBA at NetFx Corporation. A user, Scott, is maintaining the records of all the employees in the EMPLOYEEtable. Initially, the salary of the employee, ’E0025’, was $1800. On 1 May 2004, the salary of the employee, ’E0025’, was increased by $200.  
The user, Scott, issued the following statement to modify the record of the employee, ’E0025’:  
SQL>UPDATE EMPLOYEE  SET SALARY = 2000  
WHERE EMPNO = ’E0025’;  
SQL>COMMIT;  
On December 1, 2004, the salary of the employee, ’E0025’, was increased by $400. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’:  
SQL>UPDATE EMPLOYEE  SET SALARY = 2400  
WHERE EMPNO = ’E0025’; 
 SQL>COMMIT;  
On July 1, 2005, the salary of the employee, ’E0025’, was increased by $500. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’  
SQL>UPDATE EMPLOYEE  SET SALARY = 2900  
WHERE EMPNO = ’E0025’;  
SQL>COMMIT;  
On July 5, 2005, the HR manager asked you to generate the increment report of the employee, ’E0025’, for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report?()

    A. Flashback Drop
    B. Flashback Table
    C. Flashback Database
    D.Flashback Version Query

点击查看答案

相关考题

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题