欢迎来到建筑考试题库网 建筑考试题库官网
全部科目 > 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

点击查看答案

相关考题

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

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