网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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);
热门标签
最新试卷