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?（）
1、Examine the SQL statement that create
Examine the SQL statement that creates ORDERS table:CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS ...
2、Evaluate the SQL statement: What is
Evaluate the SQL statement:What is the result of the statement?（）A The statement produces an error at line 1.B The statement produces an erro...
3、Which SQL statement defines the FOREIG
Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? （）A CREATE TABLE EMP (empno NUMBER(4), ename V...
4、Evaluate this SQL statement: In the
Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?（）A Selection, projection, joinB Difference,...
5、While tuning a SQL statement, the SQL
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What...
6、Evaluate the SQL statement DROP TABLE
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）A You cannot roll back this statement.B A...