某学院oracle期末试题【原题】

一、选择题（40分）

Oracle发出下列select语句：

SQL> select e.empno, e.ename, d.loc

   2 from emp e, dept d

   3 where e.deptno = d.deptno

   4 and substr(e.ename, 1, 1) = ‘S’;

下列哪个语句是Oracle数据库中可用的ANSI兼容等价语句？

A．select empno, ename, loc from emp join dept on emp.deptno = dept.deptno where

   substr(emp.ename, 1, 1) = ‘S’;

B．select empno, ename, loc from emp, dept on emp.deptno = dept.deptno where

   substr(emp.ename, 1, 1) = ‘S’;

C．select empno, ename, loc from emp join dept where emp.deptno = dept.deptno and

   substr(emp.ename, 1, 1) = ‘S’;

D．select empno, ename, loc from emp left jo