关于闪回数据库，没有他多要说的，之所以做下面的这个实验，是因为这样的一个问题

68.  Which  two  operations  can  be  flashed  back  using  the  Flashback  technology?  (Choose  two.)
A.  DROP  USER  SMITH;
B.  DROP  TABLE  EMPLOYEES;
C.  DROP  TABLESPACE  USERS;
D.  ALTER  TABLE  SALES_REP  DROP  PARTITION  P1;
E.  ALTER  TABLE  EMPLOYEES  DROP  COLUMN  DESIG_ID;
大家再帮我看看这题    题库答案是    AB      我觉得题库错了   

我拿E答案来举一个例子，其实关于其他的答案 ，也可以非常快速和简单的模拟出来。

SQL> conn / as sysdba
Connected.
SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------
YES

SQL> conn scott/tiger
Connected.
SQL>
SQL>
SQL>
SQL> select sysdate from dual;

SYSDATE
-------------------
2012-05-30 11:49:04

SQL> alter table e drop (sal);

Table altered.

SQL> conn / as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  314572800 bytes
Fixed Size                  1219184 bytes
Variable Size             142607760 bytes
Database Buffers          167772160 bytes
Redo Buffers                2973696 bytes
Database mounted.
SQL> flashback database to timestamp  
  2  to_timestamp('2012-05-30 11:49:04','yyyy-mm-dd hh24:mi:ss');

Flashback complete.

SQL> alter database open resetlogs;

Database altered.

SQL> conn scott/tiger
Connected.
SQL> desc e
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ENAME                                              VARCHAR2(10)
 JOB                                                VARCHAR2(9)
 MGR                                                NUMBER(4)
 HIREDATE                                           DATE
 SAL                                                NUMBER(7,2)
 COMM                                               NUMBER(7,2)
 DEPTNO                                             NUMBER(2)