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
答案解析:有
微信扫一扫手机做题