oracle试卷1.docVIP

SCCE oracle内测模拟笔试 第1套 选择题(共50题，每题2分，共100分。多选题选不全或选错都不得分。) 1． 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数据库中可用的兼容等价语句？ 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, l