多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

Your database instance is configured with automatic undo management and the UNDO_RETENTIONparameter 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 onthe 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 shutdown.
  • D、The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题