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

Oracle认证考试

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

A user named Arren is executing this query:   select table_name,operation,undo_sql  from  flashback_transaction_query t,  (select versions_xid as xid  from employees versions between scn minvalue and maxvalue  where employee_id = 123) e  where t.xid = e.xid;   When the query runs,he receives an ORA-01031: insufficient privileges error. Since the user owns the employees table,you know that it is not the problem.  Which of the following SQL statements will correct this problem?()

  • A、 GRANT SELECT ANY TRANSACTION TO ARREN
  • B、 GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN
  • C、 GRANT SELECT_ANY_TRANSACTION TO ARREN
  • D、 GRANT FLASHBACK TO ARREN
  • E、 GRANT SELECT ANY VIEW TO ARREN
正确答案:A
答案解析:
进入题库查看解析

微信扫一扫手机做题