单项选择题
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
相关考题
-
单项选择题
Attheendofthefinancialyear,anaccountsaccumulationbatchisrun.Thisbatchupdatesthecompany’saccountingrecords.Duringthebatchrunprocess,someincorrectentrieswereinsertedintotheACCOUNTtable.Youidentifiedthebugandimmediatelystoppedthebatchrunprocess,but3000incorrectrecordswereinsertedintotheACCOUNTtablebeforethebatchprocesswasstopped.Youwanttorecoverthetabletothestateitwasat11:50P.M.Whichflashbackfeaturewillyouuse?()
A. Flashback Drop
B. Flashback Database
C. Flashback Table
D. Flashback Version Query -
多项选择题
You issued the following command: SQL> DROP TABLE MYTABLE; SQL> SHOW RECYCLEBIN The following output is returned: ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME ------------- ------------------------------ --------------- -------------------- MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0 TABLE 2005-01-13:20:11:31 You want to drop the table, MYTABLE, from the Recycle Bin. Which two commands can you issue to accomplish the desired task?()
A. DROP TABLE MYTABLE PURGE;
B. PURGE RECYCLEBIN;
C. PURGE TABLE MYTABLE;
D. PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0; -
多项选择题
YouareperformingflashbackoftheEMPLOYEEtableinSCOTT’sschemabecausesomeincorrectdatawasinsertedintothetableandcommittedbymistake.WhichtwoclauseswillyouuseintheFLASHBACKTABLEstatementforusingtheFlashbackTablefeature?()
A. RESETLOGS
B. TO TIMESTAMP
C. TO BEFORE DROP
D. RENAME TO
E. TO SCN
