A. WHERE B. HAVING C. RESTRICT D. GROUP BY E. ORDER BY
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';;
A. You can join a maximum of two tables through an equijoin. B. You can join a maximum of two columns through an equijoin. C. You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement. D. To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns. E. You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.