29.Your database instance is configured with automatic undo management and the UNDO_RETENTION

最新推荐文章于 2023-05-04 09:36:45 发布

今年我18

最新推荐文章于 2023-05-04 09:36:45 发布

阅读量616

点赞数

分类专栏： 1z0-052 文章标签： 1z0-052

本文链接：https://blog.csdn.net/dwj19830118/article/details/51943854

版权

1z0-052 专栏收录该内容

187 篇文章 1 订阅

订阅专栏

29.Your database instance is configured with automatic undo management and the UNDO_RETENTION
parameter is set to 900 seconds. You executed the following command to enable retention guarantee:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
What effect would this command have on the database?
A.The extents in the undo tablespace retain data until the next full database backup.
B.The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes.
C.The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down.
D.The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Area before being overwritten.
答案：B
解析：设置该命令后，undo在保留时间内不能被覆盖
因此选择B