QUESTION 13
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.
Which two statements are true regarding the outcome of this action? (Choose two)
A. All the related indexes and views are automaticallydropped
B. The flashback drop feature can recover only the table structure
C. Only the related indexes are dropped where as views are invalidated
D. The flashback drop feature can recover both the table structure and its data
Answer: CD
同97题:http://blog.csdn.net/rlhua/article/details/14119203
Explanation/Reference:
Section: Database Architecture & Resource Management, RAC, ASM
当数据库的RECYCLEBIN参数设置为ON时,删除SCOTT模式下的PRODUCTS表会产生什么效果?本文探讨了这一操作的具体后果,并解析了哪些元素会被自动移除及闪回删除特性能够恢复的内容。
530万+

被折叠的 条评论
为什么被折叠?



