itgle.com

Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns:LAST NAME VARCNAR2(35) NOT NULLSALARY NUMBER(9,2) NOT NULLCOMMISION_PCT NUMBER(4,2)Which statement ensur

题目

Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns:LAST NAME VARCNAR2(35) NOT NULLSALARY NUMBER(9,2) NOT NULLCOMMISION_PCT NUMBER(4,2)Which statement ensures that a value is displayed in the calculated columns for all employees? （）

A. SELECT last_name, 12*salary* commission_pct FROM emp;

B. SELECT last_name, 12*salary* (commission_pct,0) FROM emp;

C. SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;

D. SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;

相似考题

1.客户需要计算EMP表中所有职工12*salary* commission_pct的值.EMP表结构如下:LAST NAME VARCNAR2(35)NOT NULL SALARY NUMBER(9,2)NOT NULL COMMISION_PCTNUMBER(4,2)哪个语句可以查询计算EMP表中所有职工行?()A.SELECT last_name，12*salary* commission_pct FROM empB.SELECT last_name，12*salary*（commission_pct，0）FROM empC.SELECT last_name，12*salary*（nvl（commission_pct，0））FROM emp如果oracle第一个参数为空那么显示第二个参数的值，如果第一个参数的值不为空，则显示第一个参数本来的值D.SELECT last_name，12*salary*（decode（commission_pct，0））FROM emp

2.How long() you() a member of the club?A.have,,joinedB.have,,beenC.has,,joinedD.has,,been

3.1.publicclassSimpleCalc{2.publicintvalue；3.publicvoidcalculate（）{value+=7；}4.}And：1.publicclassMultiCalcextendsSimpleCalc{2.publicvoidcalculate（）{value-=3；}3.publicvoidcalculate（intmultiplier）{4.calculate（）；5.super.calculate（）；6.value*=multiplier；7.}8.publicstaticvoidmain（String[]args）{9.MultiCalccalculator=newMultiCalc（）；10.calculator.calculate（2）；11.System.out.println（”Valueis：+calculator.value）；12.}13.}Whatistheresult？（）

4.EMPLOYEES中职员编号为90的职员的commission_pct为空值,salary为1000,语句select12*salary*(commission_pct＋0.2)comm from EMPLOYEES;comm显示的结果是()。A.12000B.0C.2400D.NULL

更多“Management has asked you to calculate the value 12*salary* commission_pct for all the empl ”相关问题

  • 第1题：

    The EMPLOYEE tables has these columns:LAST_NAME VARCHAR2(35)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(5,2)You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column.Which SQL statement displays the desired results? （）

    A. SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;

    B. SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;

    C. SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;

    D. SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;


    参考答案：D

  • 第2题：

    YouareanEnterpriseArchitectinalargeITorganization.YourorganizationhasdeployedapplicationsonavarietyofcontainerssuchasWLS，WebSphere，andJBoss.Whywouldyouconsiderconsolidatingonasingletypeofcontainer（insteadofmix）？（）

    A.Guaranteeofhigherapplicationperformanceandreliabilityifthetransactionsareflowingbetweeninstancesofthesamecontainertype.

    B.EasiertobuildaSharedServicesinfrastructurethatcanprovidebestpractices，toolsandexpertisearoundHA/Management....withasingletypeofcontainerthanamixofmultipletypes

    C.You’llsaveonhardwarecostswithahomogenousenvironment

    D.It’sanecessarystepinourmovetowardadoptingSOA


    参考答案：B

  • 第3题：

    原始细胞CD41阳性的急性白血病属FAB分类的

    A.ALL-12
    B.ALL-M6
    C.ALL-M3
    D.ALL-M7
    E.ALL-M4

    答案：D
    解析：
    CD41为巨核细胞系分化发育过程学特异性标记，而根据中国急性白血病分型标准，巨核细胞白血病归于M7亚型。

  • 第4题：

    SeethebuildinstructionsformanagingCoherencevia&e

    SeethebuildinstructionsformanagingCoherenceviaJMXandputthestepsinorder.

    （）

    1.Updateset-env.cmd（orset-env.shifyouarebuildingonUNIX）toreflectyoursystemenvironment.

    2.Openacommandshellandexecuteset-env.cmd（orsourceset-env.shifyouarebuildingonUNIX）

    3.Runantbuild.

    4.Deploythejmx-console.warfilefoundunderthebuilddirectorytoyourapplicationserver.BesuretostartyourapplicationserverJVMwiththenecessaryCoherence

    ManagementFrameworkoverrides.Forexample：-Dtangosol.coherence.management=all

    5.Toremovebuildartifactsfromyourfilesystem，run’antclean’


    参考答案：A

  • 第5题：

    下面vb6.0中tagname,name,value有什么区别呀?

    webbrowser1.document.all(i).tagname

     webbrowser1.document.all(i).name

     webbrowser1.document.all(i).value


    比如document.all(i)是<input type="text" value="abcd" name="t1"/>那么这里tagname就是inputname就是t1value就是abcd,他们都是该元素的属性，如果不存在该属性那么你在引用的时候就会出现错误。
    比如document.all(i)是<input type="text" value="abcd" name="t1"/>
    那么这里tagname就是input
    name就是t1
    value就是abcd,他们都是该元素的属性，如果不存在该属性那么你在引用的时候就会出现错误。

相关内容