试题详情
- 单项选择题 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
关注下方微信公众号,在线模考后查看
热门试题