Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. EMPLOYEES NOT NULL, EMPLOYEE_ID NUMBER Primary Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, Primary DEPARTMENT_ID NUMBER Key VARCHAR2 DEPARTMENT_NAME (30) References NGR_ID MGR_ID NUMBER column of the EMPLOYEES table Foreign key to LOCATION_ID NUMBER LOCATION_ID column of the LOCATIONS table LOCATIONS NOT NULL, Primary LOCATION_ID NUMBER Key VARCHAR2 CITY |30) Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?（） -题库考试答案搜索网

Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. EMPLOYEES NOT NULL, EMPLOYEE_ID NUMBER Primary Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, Primary DEPARTMENT_ID NUMBER Key VARCHAR2 DEPARTMENT_NAME (30) References NGR_ID MGR_ID NUMBER column of the EMPLOYEES table Foreign key to LOCATION_ID NUMBER LOCATION_ID column of the LOCATIONS table LOCATIONS NOT NULL, Primary LOCATION_ID NUMBER Key VARCHAR2 CITY |30) Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?（）

多选题

2022-01-18 16:49

A、SELECT emp_name, department_name, city FROM employees e JOIN departments d USING (department_id) JOIN locations 1 USING (location_id) WHERE salary > 10000;
B、SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 JOIN ON (e.department_id = d.department id) AND (d.location_id =1.location_id) AND salary > 10000;
C、SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 WHERE salary > 10000;
D、SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 WHERE e.department_id = d.department_id AND d.location_id = 1.location_id AND salary > 10000;
E、SELECT emp_name, department_name, city FROM employees e NATURAL JOIN departments, locations WHERE salary > 10000;

查看答案

正确答案

A | D

试题解析

标签： CMS专题 Oracle认证考试 1Z0-007

感兴趣题目

The carrier is liable for loss of or damage to the goods or delay in delivery caused by fire，（）the claimant proves that the fire arose from fault or neglect on the part of the carrier，his servants or agents.

The（）enables water to be blow down or emptied from the boilerIt may be used when partially or completely emptying the boiler.

The guard, fencing or shielding for moving parts or machinery can be removed for repair only when the machinery it belongs to（）

The merchant undertakes that no claim or allegation shall be made against any servant，agent or subcontractor of the carrier which（）to impose upon any of them or any liability whatsoever in connection with the goods.

Although the Shipowner may be responsible for the loss or damage to the goods，his liability may be limited（）the terms of the contract or the statute.

（）shall be liable for loss of and damage to the Vessel and／or goods arising or resulting from inaccuracies in stating the description，quantity，weight，measurement or contents.

Every deliberate act of wrongdoing by the master or any of the crew against the ship or cargo，without the authorization or privity of the Shipowner or his agent，is（）.

（）, or drum is used for hauling in or letting out the wires or ropes which will fasten the ship to the shore.

A salvor may be（）the whole or part of the payment due under Salvage Convention to the extent that the salvage operations have become necessary or more difficult because of fault or neglect on his part or if the salvor has been guilty of fraud or other dishonest conduct.

The （） is used for hauling in or letting out the wires or ropes.

The（）may examine or re-examine the goods or take samples from them straightaway in the absence of the consignee or the consignor whenever it considers this necessary.

Should it appear that war or blockade would prevent the vessel from safely reaching the port of destination and / or discharging the goods thereat，the Carrier（）.