试题详情
单项选择题 Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?()

A、SELECT*FROMDEPT;

B、SELECT*FROMSCOTT.DEPT;

C、SELECT*FROMDBASCOTTDEPT;

D、SELECT*FROMALL_USERSWHEREUSER_NAME=';SCOTT';ANDTABLENAME=';DEPT';;

  • B
  • 关注下方微信公众号,在线模考后查看

热门试题