Examine the data from the EMP table:The COMMISSION column shows the monthly commission earned by the employee.Which three tasks would require subqueries or joins in order to perform in a single step?（）A. Deleting the records of employees who do not earn c

题目

Examine the data from the EMP table:The COMMISSION column shows the monthly commission earned by the employee.Which three tasks would require subqueries or joins in order to perform in a single step?（）

A. Deleting the records of employees who do not earn commission.

B. Increasing the commission of employee 3 by the average commission earned in department 20.

C. Finding the number of employees who do NOT earn commission and are working for department 20.

D. Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3.

E. Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table.

F. Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.

相似考题

1.The Ad Council’s () is to identify a select number of significant public issues.A、permissionB、admissionC、missionD、commission

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

3.[A] assignment[B] temptation[C] attempt[D] commission

4.客户需要计算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

更多“Examine the data from the EMP table:The COMMISSION column shows the monthly commission ear ”相关问题

  • 第1题：

    The Foreign Minister made an excellent ____ ernational situation.

    A: committee

    B: command

    C: comment

    D: commission


    参考答案： C

  • 第2题：

    1.publicclassEmployee{2.Stringname；3.doublebaseSalary；4.Employee（Stringname，doublebaseSalary）{5.this.name=name；6.this.baseSalary=baseSalary；7.}8.}And：1.publicclassSalespersonextendsEmployee{2.doublecommission；3.publicSalesperson（Stringname，doublebaseSalary，4.doublecommission）{5.//insertcodehere6.}7.}Whichcode，insertedatline7，completestheSalespersonconstructor？（）

    A.this.commission=commission；

    B.superb（）；commission=commission；

    C.this.commission=commission；superb（）；

    D.super（name，baseSalary）；this.commission=commission；

    E.super（）；this.commission=commission；

    F.this.commission=commission；super（name，baseSalary）；


    参考答案：D

  • 第3题：

    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

  • 第4题：

    Whichtwocodefragments,insertedindependentlyatline12,willcompile?()

    A.super（name，baseSalary）；

    B.this.commission=commission；

    C.super（）；this.commission=commission；

    D.this.commission=commission；super（）；

    E.super（name，baseSalary）；this.commission=commission；

    F.this.commission=commission；super（name，baseSalary）；

    G.super（name，baseSalary，commission）；


    参考答案：A, E

  • 第5题：

    The EMPLOYEES table contains these columns:LAST_NAME VARCHAR2 (25)SALARY NUMBER (6,2)COMMISSION_PCT NUMBER (6)You need to write a query that will produce these results:1. Display the salary multiplied by the commission_pct.2. Exclude employees with a zero commission_pct.3. Display a zero for employees with a null commission value. Evaluate the SQL statement:SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEESWHERE COMMISSION_PCT IS NOT NULL;What does the statement provide? （）

    A. All of the desired results

    B. Two of the desired results

    C. One of the desired results

    D. An error statement


    参考答案：C

  • 第6题：

    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;


    参考答案：C

相关内容