网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

Evaluate this SQL statement:SELECT ename, sal, 12* sal+100 FROM emp;The SAL column stores the monthly salary of the employee. Which change must be made to the abovesyntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"? ()

A. No change is required to achieve the desired results.

B. SELECT ename, sal, 12* (sal+100) FROM emp;

C. SELECT ename, sal, (12* sal)+100 FROM emp;

D. SELECT ename, sal +100,*12 FROM emp;


参考答案

更多 “ Evaluate this SQL statement:SELECT ename, sal, 12* sal+100 FROM emp;The SAL column stores the monthly salary of the employee. Which change must be made to the abovesyntax to calculate the annual compensation as monthly salary plus a monthly bonus of $100, multiplied by 12? ()A. No change is required to achieve the desired results.B. SELECT ename, sal, 12* (sal+100) FROM emp;C. SELECT ename, sal, (12* sal)+100 FROM emp;D. SELECT ename, sal +100,*12 FROM emp; ” 相关考题
考题 以下说法错误的是( )A.SELECT max(sal),deptno,job FROM EMP group by sal;B.SELECT max(sal),deptno,job FROM EMP group by deptno;C.SELECT max(sal),deptno,job FROM EMP;D.SELECT max(sal),deptno,job FROM EMP group by job;

考题 以下插入记录正确的( )A.insert into emp(ename,hiredate,sal) values (value1,value2,value3);B.insert into emp (ename,sal)values(value1,value2,value3);C.insert into emp (ename)values(value1,value2,value3);D.insert into emp (ename,hiredate,sal)values(value1,value2);

考题 UserSCOTTexecutesthefollowingcommandontheEMPtablebuthasnotissuedCOMMIT,ROLLBACK,oranydatadefinitionlanguage(DDL)command:SQLSELECTenameFROMempWHEREjob=’CLERK’FORUPDATEOFempno;SCOTThasopenedanothersessiontoworkwiththedatabaseinstance.WhichthreeoperationswouldwaitwhenissuedinSCOTT’ssecondsession()A.LOCKTABLEempINSHAREMODE;B.LOCKTABLEempINEXCLUSIVEMODE;C.UPDATEempSETsal=sal*1.2WHEREjob=ANAGER?UPDATEempSETsal=sal*1.2WHEREjob=?ANAGER?D.INSERTINTOemp(empno,ename)VALUES(1289,’Harry’);E.SELECTenameFROMempWHEREjob=’CLERK’FORUPDATEOFempno

考题 emp表是雇员信息表,sal字段存放是的雇员的月薪,以下哪个变量可以存放sal类型的值() A.v_sal emp%rowtype;B.v_sal emp.sal%type;C.v_sal emp.sal.%type;D.v_sal %type(emp.sal);E.v_sal (emp.sal)%type;

考题 在PL/SQL中定义一个可以存放雇员表(EMP)的员工名称(ENAME)的PL/SQL表类型,应该() A.type array arr_type[emp.ename%type] index by binary_integer;B.type table arr_type[emp.ename%type] index by binary_integer;C.type arr_type is table of emp.ename%type index by binary_integer;D.type arr_type is pl_sql table of emp.ename%type index by binary_integer;

考题 授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是()。 A.GRANT CHANGE ON SCOTT.EMP TO SAB.GRANT UPDATE ON SCOTT.EMP(SAL) TO SAC.GRANT UPDATE (SAL) ON SCOTT.EMP TO SAD.GRANT MODIFY ON SCOTT.EMP(SAL) TO SA

考题 (33)如果对关系 emp(eno, ename, salary)成功执行下面的SQL语句:CREATE CLUSTER INDEX name_index ON emp(salary)其结果是A)在 emp表上按sal娜升序创建了一个聚簇索引B)在 emp表上按salary降序创建了一个聚簇索引C)在 emp表上按salary升序创建了一个唯一索引D)在 emp表上按salary降序创建了一个唯一索引

考题 以下查询语句合法的是哪三项?() A.selectempno ,sum(sal) from scott.emp group by deptnoB.select*fromscott.empC.selectsum(sal)fromscott.empgroupbydeptnoD.selectcount(empno) from scott.emp

考题 列出薪水高于所在部门平均工资的员工信息()。A.select deptno,ename,sal from emp a where sal> (select avg(a.sal) from emp where deptno=a.deptno);B.select deptno,ename,sal from emp a where sal> (select avg(sal) from emp where deptno=a.deptno);C.select a.deptno,a.ename,a.sal from emp a,emp b where a.deptno=b.deptno and a.sal>avg(b.sal);D.select a.deptno,a.ename,a.sal from emp a,emp b where a.deptno=b.deptno and b.sal>avg(a.sal);