ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 1Z0-053 Q686(Flashback Table)

Oracle OCP 1Z0-053 Q686(Flashback Table)

原创 Oracle 作者:abstractcyj 时间:2016-03-24 11:23:21 0 删除 编辑
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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8520577/viewspace-2063006/,如需转载,请注明出处,否则将追究法律责任。

上一篇: ORA-01190&ORA-19909
请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    560
  • 访问量
    858478