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

Oracle认证考试

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

The EMP table exists in your schema. You want to execute the following query:   SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ’6’ MINUTE)   WHERE ename = ’ALLEN’;   What are the minimum requirements for the statement to execute successfully?()

  • A、 ARCHIVELOG mode must be enabled
  • B、 Row Movement must be enabled for the table
  • C、 FLASHBACK must be set to ON for the database
  • D、 The UNDO_MANAGEMENT parameter must be set to AUTO
  • E、 The UNDO_RETENTION parameter must be set appropriately
正确答案:D,E
答案解析:
进入题库查看解析

微信扫一扫手机做题