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

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
答案解析:
进入题库查看解析

微信扫一扫手机做题