找考题网-背景图
单项选择题

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

热门试题

单项选择题You are working as a Database Administrator. You erroneously dropped an important table named WAREHOUSE_DETAILS. The table resides in a non-SYSTEM tablespace.  The following dependent objects have been defined on the dropped table:       Due to limited space, some of the indexes and triggers have been removed from the Recycle Bin. You decide to recover the table by using Flashback Drop. You execute the following statement: SQL>FLASHBACK TABLE warehouse_details TO BEFORE DROP;   What will be the implication of executing this statement?()

A. Only the WAREHOUSE_DETAILS table is recovered, and none of the dependent objects are recovered.
B. The WAREHOUSE_DETAILS table is recovered along with the NOT NULL constraints, primary key constraint, and the referential integrity constraints.
C. The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the indexes and triggers previously removed from the Recycle Bin.
D. The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the referential integrity constraints and the indexes and triggers previously removed from the Recycle Bin.