ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-066

043-066

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-06 11:31:51 0 删除 编辑
66. Which two statements are correct regarding the Oracle Flashback D
rop feature? (Choose two.)
A. Recycle bin exists for the tables only in non-SYSTEM, locally mana
ged tablespaces.
B. You can flash back a dropped table provided row movement has been
enabled on the table.
C. If you drop an index before dropping its associated table, then th
e recovery of the index is not supported when you flash back the drop
ped table.
D. When you execute the DROP TABLESPACE? INCLUDING CONTENTS command,
the objects in the tablespace are places in the recycle bin.
E. When a dropped table is moved to the recycle bin, only the table i
s renamed to a system-generated name; its associated objects and cons
traints are not renamed.
F. If you drop a table that is protected by the recycle bin, then ass
ociated bitmap-joined indexes and materialized view logs are also sto
red in the recycle bin.
Answer: A, C
只有不是系统表空,本地管理的表才能flashback
删除表时,物化视图不放在recyclebin中。
drop表时不光表名字变,其他的名字也变。
offline:离线,一旦offline,该表空间不能被访问 
including   contents:包括所有的内容。drop   tablespace   mytbs   including   contents就是把表空间连同其中的内容全部删除。 
如果不加including   contents,则只能删除空的表空间,而存有内容的表空间是无法删除的。
Flashback table table_name to scn(恢复被删除的记录)才需要启动row
movement;故B 错

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

上一篇: 043-065
下一篇: 043-067
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    213919