Which line of code has an error?
A. SELECT dname, ename
B. FROM emp e, dept d
C. WHERE emp.deptno=dept.deptno
D. ORDER BY 1,2
查看答案
Which of the following statements will not implicitly begin a transaction?
A. INSERT
B. UPDATE
C. DELETE
D. SELECT FOR UPDATE
E. None of the above, they all implicitly begin a transaction.
Consider the following query: SELECT dname, ename FROM dept d, emp a WHERE d.deptno=e.deptno ORDER BY dname, ename; What type of join is shown?
A. Self-join
B. Equijoin
C. Outer join
D. Non-equijoin
When using multiple tables to query information, in which clause do you specify the table names?
A. HAVING
B. GROUP BY
C. WHERE
D. FROM
Which two operators are not allowed when using an outer join between two tables? (10分)
A. OR
B. AND
C. IN
D. =