686. You execute the following FLASHBACK TABLE command:
Which two statements are correct?(Choose two.)
A.The EMP table that was dropped by mistake earlier is restored.
B.The FLASHBACK TABLE statement is executed as a single transaction.
C.The FLASHBACK TABLE statement does not maintain existing indexes on the EMP table.
D.The changes made to the EMP table since the specified time are undone if no constraint is violated
during flashback.
Answer:BD
答案A是错误的,验证如下:
SQL> create table t1 as select rownum rn from dual connect by rownum <= 10000;
Table created.
SQL> select sysdate from dual;
SYSDATE
---------
24-MAR-16
SQL> select to_char(sysdate, 'yyyymmdd hh24:mi:ss') from dual;
TO_CHAR(SYSDATE,'
-----------------
20160324 11:16:57
SQL> drop table t1;
Table dropped.
SQL> flashback table t1 to timestamp to_timestamp('20160324 11:16:57','yyyymmdd hh24:mi:ss');
flashback table t1 to timestamp to_timestamp('20160324 11:16:57','yyyymmdd hh24:mi:ss')
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> flashback table t1 to before drop;
Flashback complete.
SQL> select count(*) from t1;
COUNT(*)
----------
10000
参考: http://blog.csdn.net/rlhua/article/details/17417859
![](http://img.blog.itpub.net/blog/attachment/201603/24/8520577_1458789684d1NT.png?x-oss-process=style/bb)
Which two statements are correct?(Choose two.)
A.The EMP table that was dropped by mistake earlier is restored.
B.The FLASHBACK TABLE statement is executed as a single transaction.
C.The FLASHBACK TABLE statement does not maintain existing indexes on the EMP table.
D.The changes made to the EMP table since the specified time are undone if no constraint is violated
during flashback.
Answer:BD
答案A是错误的,验证如下:
SQL> create table t1 as select rownum rn from dual connect by rownum <= 10000;
Table created.
SQL> select sysdate from dual;
SYSDATE
---------
24-MAR-16
SQL> select to_char(sysdate, 'yyyymmdd hh24:mi:ss') from dual;
TO_CHAR(SYSDATE,'
-----------------
20160324 11:16:57
SQL> drop table t1;
Table dropped.
SQL> flashback table t1 to timestamp to_timestamp('20160324 11:16:57','yyyymmdd hh24:mi:ss');
flashback table t1 to timestamp to_timestamp('20160324 11:16:57','yyyymmdd hh24:mi:ss')
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> flashback table t1 to before drop;
Flashback complete.
SQL> select count(*) from t1;
COUNT(*)
----------
10000
参考: http://blog.csdn.net/rlhua/article/details/17417859
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8520577/viewspace-2063006/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8520577/viewspace-2063006/