第1题:
Written notice shall be sent to all directors, indicating all matters to be considered().
A、hereby
B、therefore
C、otherwise
D、thereafter
第2题:
第3题:
A、mathematic teachers
B、mathematics teacher
C、mathematics teachers
D、mathematic's teachers
第4题:
Periodic publications notifying changes in,or additions to,previously published navigational data is ________ .
A.Supplements
B.Annual Summary
C.Navigational Warnings
D.Notice to Mariners
第5题:
A. SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
C. SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
D. SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
E. SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
F. SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
第6题:
___ I’d like to welcome you to the conference.
A、All first
B、First of all
C、Of all the first
D、All of the first
第7题:
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;
第8题:
第9题:
A. To find the tax percentage for each of the employees.
B. To list the name, job id, and manager name for all the employees.
C. To find the name, salary, and department name of employees who are not working with Smith.
D. To find the number of employees working for the Administrative department and earning less then 4000.
E. To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
第10题:
Please accept this as notice that MV Blue Ocean is now berthed at your dock and is in all respects ready to load her cargo as per terms of the charter-party dated at New York on June 10,2006. This sentence is likely to appear in ______.
A.Declaration of Deadweight Tonnage of Cargo
B.Notice of Demurrage
C.Notice of Despatch
D.Notice of Readiness