Application
Exception
Access
Glance
第1题:
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)DEPARTMENT_ID NUMBERSALARY NUMBERWhat is the correct syntax for an inline view? ()
A. SELECT a.last_name, a.salary, a.department_id, b.maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary < b.maxsal;
B. SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))
C. SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);
D. SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);
第2题:
A.netrpcjoin-mlocalhost-ldap="ldap.ldapserver.comComputers\BusinessUnit\Department\Servers"
B.rpcclient-c"joinComputers\BusinessUnit\Department\Servers"
C.netadsjoinou="Computers\BusinessUnit\Department\Servers"
D.netadsjoin"Computers\BusinessUnit\Department\Servers"
第3题:
A.没有给表employees和表departments加别名
B.没有给列department_id加别名
C.不能用employees.department_id=departments.department_id作为条件
D.SELECT后面的department_id没有指定是哪个表
第4题:
在执行语句SELECT department_id FROM employees,departments WHERE employees.department_id= departments.department_id;时报错,原因是()。
第5题:
Which department do you work in on board?()
第6题:
ExhibitExamine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees‘ last names, along with their manager‘s last names and their department names. Which query would you use?()
A. SELECT last_name, manager_id, department_name FROM employees e FULL OUTER JOIN department d ON (e.department_id = d.department_id);
B. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.managaer_id = m.employee_id) LEFT OUTER JOIN department d ON (e.department_id = d.department_id);
C. SELECT e.last_name, m.last_name, department_name FROM employees e RIGT OUTER JOIN employees m on ( e.manager_id = m.employee_id) FULL OUTER JOIN department d ON (e.department_id = d.department_id);
D. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGT OUTER JOIN department d ON (e.department_id = d.department_id);
E. SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id)
F. SELECT last_name, manager_id, department_name FROM employees e JOIN department d ON (e.department_id = d.department_id);
第7题:
At any rate ______ is liable for delay in obtaining the necessary Customs House papers for discharging,when the delay arises from the fact that special papers are required for the particular cargo carried.
A.the Charterer
B.the Shipowner
C.the Shipper
D.the Receiver
第8题:
A.State
B.Justice
C.Labor
D.Defense
第9题:
游戏《DOTA》的全名是()
第10题:
A manager calls with an urgent issue and needs their machine fixed as soon as possible. Thetechnician arrives and the office is empty, however there are several confidential papers on the desk. Which of the following should the technician do NEXT?()