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

Oracle认证考试

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

A database user SMITH tries to query the V$SESSION view and fails to access it as follows: SQL> connect smith/smith  Connected.  SQL> SELECT * FROM v$session;  SELECT * FROM v$session *  ERROR at line 1:  ORA-00942: table or view does not exist  Which are the two possible solutions to enable SMITH to query the data in V$SESSION()

  • A、granting SELECT privilege to SMITH on V$SESSION
  • B、granting SELECT privilege to SMITH on V_$SESSION
  • C、asking the user SMITH to run the catalog.sql script
  • D、granting SELECT privilege to SMITH on V$FIXED_TABLES
  • E、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
  • F、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
正确答案:B,F
答案解析:
进入题库查看解析

微信扫一扫手机做题