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

Oracle认证考试

题库首页>其他计算机考试>Oracle认证考试

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';;
查看答案

微信扫一扫手机做题