Monday, 27 August 2012

Scott issues the SQL statements: CREATE TABLE dept (deptno number (2) dname VARCHAR2 (14) loc VARCHAR2 (13)); GRANT SELECT ON DEPT TO SUE; If Sue needs to select from Scott's DEPT table, which command should she use? | Oracle

A. SELECT * FROM DEPT
B. SELECT * FROM SCOTT.DEPT
C. SELECT * FROM DBA.SCOTT.DEPT.
D. SELECT * FROM ALL_USERS WHERE USER_NAME = 'SCOTT' AND TABLE NAME= 'DEPT';

Ans:B

No comments: