- 论坛徽章:
- 0
|
1z0-007 考试是 Oracle 公司的Oracle Introduction to Oracle9i: SQL认证考试官方代号,通过此项认证可以说是你进入职场的一块敲门砖。Oracle认证证书是让hr了解到来应聘的人通过了Oracle数据库方面的技术考试。其中,Testinside认证题库 的 1z0-007 考试题库软件是Oracle 认证必备辅导工具。<br /><br />1. Which are iSQL Plus commands? (Choose all that apply.)<br />A.INSERT<br />B.UPDATE<br />C.SELECT<br />D.DESCRIBE<br />E.DELETE<br />F.RENAME<br />Answer: D<br />2. Evaluate this SQL statement:<br />SELECT ename, sal, 12 sal+100<br />FROM emp;<br />The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to <br />calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?<br />A.No change is required to achieve the desired results.<br />B.SELECT ename, sal, 12 sal+100)<br />FROM emp;<br />C.SELECT ename, sal, (12 sal)+100<br />FROM emp;<br />D.SELECT ename, sal+100 12<br />FROM emp;<br />Answer: B<br /><br /><br />[<i> 本帖最后由 oracle_1z0 于 2010-11-13 16:10 编辑 </i>] |
|