此题为判断题(对,错)。
第1题:

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);
第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);
第3题:
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;
第4题:
The company_______the chairman’s new plan.
A、adopted
B、adapted
C、carried
D、elected
第5题:
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;
第6题: