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

Oracle认证考试

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

Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee:  SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;  What effect would this statement have on the database?()

  • A、The extents in undo tablespace retain data until the next full database backup.
  • B、The extents containing committed data in the undo tablespace are never overwritten.
  • C、The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.
  • D、The extents containing committed data in the undo tablespace are not overwritten until the instance  is shut down.
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题