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 join dept on emp.deptno = dept.deptno and

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

文章来源: aaaedu.blog.csdn.net，作者：tea_year，版权归原作者所有，如需转载，请联系作者。

原文链接：aaaedu.blog.csdn.net/article/details/80533017